APPS.BEN_BENBATCH_PERSONS dependencies on BEN_PGM_F

Line 1139: from ben_pgm_f pgm

1135: -- get the default grade ladder
1136: cursor c_dflt_grade_ladder is
1137: -- select pgm.pgm_prvds_no_dflt_enrt_flag, pgm.pgm_id /* Bug 4030438 */
1138: select pgm.dflt_pgm_flag, pgm.pgm_id
1139: from ben_pgm_f pgm
1140: where pgm.pgm_id = p_grade_ladder_id
1141: and p_effective_date between effective_start_date and effective_end_date
1142: and business_group_id = p_business_group_id ;
1143:

Line 1640: ' , ben_pgm_f pgm'||

1636: ' or (paf.grade_ladder_pgm_id is null'||
1637: ' and paf.grade_id in'||
1638: ' ( select pln.mapping_table_pk_id'||
1639: ' from ben_pl_f pln'||
1640: ' , ben_pgm_f pgm'||
1641: ' , ben_plip_f plip'||
1642: ' where pln.pl_id = plip.pl_id'||
1643: ' and plip.pgm_id = pgm.pgm_id'||
1644: ' and pgm.dflt_pgm_flag = ''Y'''||

Line 1703: ' ( select 1 from ben_pgm_f pgm ' ||

1699: ' and paf.assignment_type <> ''C''' ||
1700: ' and paf.primary_flag = ''Y''' ||
1701: ' and :grade_ladder_id_date2 between paf.effective_start_date and paf.effective_end_date ' ||
1702: ' and exists ' ||
1703: ' ( select 1 from ben_pgm_f pgm ' ||
1704: ' where ' ||
1705: ' ( pgm.pgm_id = paf.grade_ladder_pgm_id OR ' ||
1706: ' pgm.dflt_pgm_flag = ''Y'' ' ||
1707: ' ) ' ||