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.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 558: l_exception_flag per_people_extra_info.pei_information1%TYPE;

554: p_date_earned IN DATE
555: ,p_business_group_id IN NUMBER
556: ,p_assignment_id IN NUMBER ) RETURN VARCHAR2 IS
557: --
558: l_exception_flag per_people_extra_info.pei_information1%TYPE;
559: --
560: cursor csr_exception_flag is
561: select pei.pei_information1
562: from per_people_f pap

Line 563: ,per_people_extra_info pei

559: --
560: cursor csr_exception_flag is
561: select pei.pei_information1
562: from per_people_f pap
563: ,per_people_extra_info pei
564: ,per_assignments_f paa
565: where paa.assignment_id = p_assignment_id
566: and paa.business_group_id = p_business_group_id
567: and paa.person_id = pap.person_id

Line 879: per_people_extra_info pei

875: nvl(pei.pei_information3,'N') FEMALE_EMP_DOC,
876: super_aged_flag(per.national_identifier, p_date_earned) SUPER_AGED_FLAG -- Bug 4124430
877: from per_people_f per,
878: per_assignments_f asg,
879: per_people_extra_info pei
880: where asg.assignment_id = p_assignment_id
881: and p_date_earned
882: between asg.effective_start_date and asg.effective_end_date
883: and per.person_id = asg.person_id

Line 1020: from per_people_extra_info pei

1016: cursor csr_ei_loss_code
1017: is
1018: select pei_information8 loss_code
1019: ,pei_information9 loss_date
1020: from per_people_extra_info pei
1021: ,per_people_f pp
1022: ,per_assignments_f paa
1023: ,per_time_periods ptp
1024: where paa.assignment_id = p_assignment_id

Line 1040: from per_people_extra_info pei

1036: cursor csr_ei_exception_code
1037: is
1038: select pei_information1 ei_exception_code
1039: ,pei_information4 ei_exception_type
1040: from per_people_extra_info pei
1041: ,per_assignments_f paa
1042: ,per_time_periods ptp
1043: where paa.assignment_id = p_assignment_id
1044: and paa.business_group_id = p_business_group_id

Line 1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;

1050: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1051: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1052: order by pei.pei_information2 desc,pei.pei_information3 desc;
1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;

Line 1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;

1051: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1052: order by pei.pei_information2 desc,pei.pei_information3 desc;
1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;

Line 1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;

1052: order by pei.pei_information2 desc,pei.pei_information3 desc;
1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1060:

Line 1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;

1053:
1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1060:
1061:

Line 1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;

1054: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1060:
1061:
1062: begin

Line 1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;

1055: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1056: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1057: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1058: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1059: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1060:
1061:
1062: begin
1063: