APPS.BEN_BENBATCH_PERSONS dependencies on BEN_PGM_F

Line 1142: from ben_pgm_f pgm

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

Line 1644: ' , ben_pgm_f pgm'||

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

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

1704: ' and paf.assignment_type <> ''C''' ||
1705: ' and paf.primary_flag = ''Y''' ||
1706: ' and :grade_ladder_id_date2 between paf.effective_start_date and paf.effective_end_date ' ||
1707: ' and exists ' ||
1708: ' ( select 1 from ben_pgm_f pgm ' ||
1709: ' where ' ||
1710: ' ( pgm.pgm_id = paf.grade_ladder_pgm_id OR ' ||
1711: ' pgm.dflt_pgm_flag = ''Y'' ' ||
1712: ' ) ' ||