eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on BEN_LER_F

Line 20: BEN_PER_IN_LER pil, ben_ler_f ler

16: vac.VACANCY_ID,paaf.person_id,paaf.assignment_id,
17: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
18: FROM
19: PER_ALL_VACANCIES vac, per_all_assignments_f paaf,
20: BEN_PER_IN_LER pil, ben_ler_f ler
21: WHERE
22: vac.BUSINESS_GROUP_ID = pBGId and
23: paaf.BUSINESS_GROUP_ID = vac.BUSINESS_GROUP_ID and
24: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and

Line 49: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler

45: SELECT
46: paaf.person_id, paaf.assignment_id, PIL.PER_IN_LER_ID,
47: PAAF.BUSINESS_GROUP_ID
48: FROM
49: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler
50: WHERE
51: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
52: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
53: paaf.vacancy_id = pVacancyId and

Line 510: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler

506: l_business_group_id NUMBER;
507: l_description varchar2(500);
508: cursor csr_assignment is
509: select PAAF.assignment_id,PAAF.BUSINESS_GROUP_ID,PIL.PER_IN_LER_ID
510: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler
511: where PAAF.person_id = pPersonId and PAAF.assignment_type='E' and
512: paaf.primary_flag='Y' and
513: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
514: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and