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.

[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 660: l_exception_flag per_people_extra_info.pei_information1%TYPE;

656: p_date_earned IN DATE
657: ,p_business_group_id IN NUMBER
658: ,p_assignment_id IN NUMBER ) RETURN VARCHAR2 IS
659: --
660: l_exception_flag per_people_extra_info.pei_information1%TYPE;
661: --
662: cursor csr_exception_flag is
663: select pei.pei_information1
664: from per_people_f pap

Line 665: ,per_people_extra_info pei

661: --
662: cursor csr_exception_flag is
663: select pei.pei_information1
664: from per_people_f pap
665: ,per_people_extra_info pei
666: ,per_assignments_f paa
667: where paa.assignment_id = p_assignment_id
668: and paa.business_group_id = p_business_group_id
669: and paa.person_id = pap.person_id

Line 1167: per_people_extra_info pei

1163: nvl(pei.pei_information3,'N') FEMALE_EMP_DOC,
1164: super_aged_flag(per.national_identifier, p_date_earned) SUPER_AGED_FLAG -- Bug 4124430
1165: from per_people_f per,
1166: per_assignments_f asg,
1167: per_people_extra_info pei
1168: where asg.assignment_id = p_assignment_id
1169: and p_date_earned
1170: between asg.effective_start_date and asg.effective_end_date
1171: and per.person_id = asg.person_id

Line 1331: from per_people_extra_info pei

1327: cursor csr_ei_loss_code
1328: is
1329: select pei_information8 loss_code
1330: ,pei_information9 loss_date
1331: from per_people_extra_info pei
1332: ,per_people_f pp
1333: ,per_assignments_f paa
1334: ,per_time_periods ptp
1335: where paa.assignment_id = p_assignment_id

Line 1351: from per_people_extra_info pei

1347: cursor csr_ei_exception_code
1348: is
1349: select pei_information1 ei_exception_code
1350: ,pei_information4 ei_exception_type
1351: from per_people_extra_info pei
1352: ,per_assignments_f paa
1353: ,per_time_periods ptp
1354: where paa.assignment_id = p_assignment_id
1355: and paa.business_group_id = p_business_group_id

Line 1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;

1361: and fnd_date.canonical_to_date(pei.pei_information2) <= ptp.end_date
1362: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1363: order by pei.pei_information2 desc,pei.pei_information3 desc;
1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;

Line 1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;

1362: and fnd_date.canonical_to_date(pei.pei_information3) >= ptp.start_date
1363: order by pei.pei_information2 desc,pei.pei_information3 desc;
1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;

Line 1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;

1363: order by pei.pei_information2 desc,pei.pei_information3 desc;
1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1371:

Line 1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;

1364:
1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1371:
1372:

Line 1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;

1365: l_ei_loss_code per_people_extra_info.pei_information8%TYPE;
1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1371:
1372:
1373: begin

Line 1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;

1366: l_ei_loss_date per_people_extra_info.pei_information9%TYPE;
1367: l_ei_exception_type per_people_extra_info.pei_information4%TYPE;
1368: l_ei_exception_code per_people_extra_info.pei_information1%TYPE;
1369: l_ei_ex_dummy1 per_people_extra_info.pei_information8%TYPE;
1370: l_ei_ex_dummy2 per_people_extra_info.pei_information9%TYPE;
1371:
1372:
1373: begin
1374: