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_ASN_BUS dependencies on PER_PEOPLE_F

Line 320: l_ASN_PERS_STA_DATE per_people_f.start_date%TYPE;

316: from per_all_people_f per
317: where per.person_id = p_person_id
318: group by business_group_id;
319: --
320: l_ASN_PERS_STA_DATE per_people_f.start_date%TYPE;
321: l_ASN_PERS_BG per_people_f.business_group_id%TYPE;
322: --
323: l_api_updating boolean;
324: --

Line 321: l_ASN_PERS_BG per_people_f.business_group_id%TYPE;

317: where per.person_id = p_person_id
318: group by business_group_id;
319: --
320: l_ASN_PERS_STA_DATE per_people_f.start_date%TYPE;
321: l_ASN_PERS_BG per_people_f.business_group_id%TYPE;
322: --
323: l_api_updating boolean;
324: --
325: begin

Line 419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.

415: select distinct(min(effective_start_date)), business_group_id
416: from per_all_people_f per
417: where per.person_id = p_assessor_person_id
418: group by business_group_id;
419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.
420: --
421: l_ASN_ASSPERS_STA_DATE per_people_f.start_date%TYPE;
422: l_ASN_ASSPERS_BG per_people_f.business_group_id%TYPE;
423: --

Line 421: l_ASN_ASSPERS_STA_DATE per_people_f.start_date%TYPE;

417: where per.person_id = p_assessor_person_id
418: group by business_group_id;
419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.
420: --
421: l_ASN_ASSPERS_STA_DATE per_people_f.start_date%TYPE;
422: l_ASN_ASSPERS_BG per_people_f.business_group_id%TYPE;
423: --
424: begin
425: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 422: l_ASN_ASSPERS_BG per_people_f.business_group_id%TYPE;

418: group by business_group_id;
419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.
420: --
421: l_ASN_ASSPERS_STA_DATE per_people_f.start_date%TYPE;
422: l_ASN_ASSPERS_BG per_people_f.business_group_id%TYPE;
423: --
424: begin
425: hr_utility.set_location('Entering:'|| l_proc, 1);
426:

Line 606: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;

602: from per_all_people_f per
603: where per.person_id = p_group_initiator_id
604: group by business_group_id;
605: --
606: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
607: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
608: --
609: begin
610: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 607: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;

603: where per.person_id = p_group_initiator_id
604: group by business_group_id;
605: --
606: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;
607: l_asn_grp_pers_bg per_people_f.business_group_id%TYPE;
608: --
609: begin
610: hr_utility.set_location('Entering:'|| l_proc, 1);
611: --