Need a join condition for this table BEN_ELIGY_PRFL_F to get Variable Rates
Summary:
I have a requirement to get the Benefits enrollment along with Variable Rate Profiles
Content (required):
below are the tables that i am using
ben_prtt_enrt_rslt prtt,
ben_pl_f plans,
ben_benefit_relations_f prel,
per_all_assignments_m paa,
cmp_salary csal,
cmp_salary_bases csbas,
ben_ler_f ler,
ben_per_in_ler pil,
per_periods_of_service ppos
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
attached the code snippet
Tagged:
0