DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on BEN_LER_F

Line 1054: FROM ben_ptnl_ler_for_per bplfp, ben_ler_f blf

1050: and p_new_start_date between effective_start_date and effective_end_date;
1051:
1052: cursor c_ben_non_GSP(cl_business_group_id number, cl_start_date date, cl_end_date date) is
1053: SELECT 1
1054: FROM ben_ptnl_ler_for_per bplfp, ben_ler_f blf
1055: where blf.ler_id = bplfp.ler_id
1056: and blf.typ_cd <> 'GSP'
1057: and blf.business_group_id = cl_business_group_id
1058: and bplfp.business_group_id = cl_business_group_id

Line 1126: ben_ler_f blf

1122: cursor c_ben_ptnl_ler_GSP(cl_business_group_id number, cl_start_date date, cl_end_date date) is
1123: SELECT bplfp.ptnl_ler_for_per_id,
1124: bplfp.object_version_number
1125: FROM ben_ptnl_ler_for_per bplfp,
1126: ben_ler_f blf
1127: where blf.ler_id = bplfp.ler_id
1128: and blf.typ_cd = 'GSP'
1129: and blf.business_group_id = cl_business_group_id
1130: and bplfp.business_group_id = cl_business_group_id