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_IE_NES_REPORT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1364: from per_assignment_extra_info

1360: /* 9768428 start */
1361: cursor csr_ppsn_override(p_asg_id number)
1362: is
1363: select aei_information1 PPSN_OVERRIDE
1364: from per_assignment_extra_info
1365: where assignment_id = p_asg_id
1366: and aei_information_category = 'IE_ASG_OVERRIDE';
1367:
1368: CURSOR cur_assignment_action_ppsn(c_person_id number,

Line 1370: c_ppsn_override per_assignment_extra_info.aei_information1%type)is

1366: and aei_information_category = 'IE_ASG_OVERRIDE';
1367:
1368: CURSOR cur_assignment_action_ppsn(c_person_id number,
1369: c_till_date date,
1370: c_ppsn_override per_assignment_extra_info.aei_information1%type)is
1371: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1372: paa.assignment_action_id),16))
1373: FROM pay_assignment_actions paa
1374: ,pay_payroll_actions ppa

Line 1380: from per_all_assignments_f paaf, per_assignment_extra_info paei

1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl
1378: WHERE paaf.person_id=c_person_id
1379: AND paa.assignment_id in (select paaf.assignment_id
1380: from per_all_assignments_f paaf, per_assignment_extra_info paei
1381: where paaf.person_id = c_person_id
1382: and paaf.assignment_id=paei.assignment_id
1383: and paei.information_type = 'IE_ASG_OVERRIDE'
1384: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 1396: c_ppsn_override per_assignment_extra_info.aei_information1%type)is

1392: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1393: AND scl.segment4 = to_char(g_employer_id);
1394:
1395: CURSOR cur_assignment_action_ytd_ppsn(c_person_id number,
1396: c_ppsn_override per_assignment_extra_info.aei_information1%type)is
1397: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1398: paa.assignment_action_id),16))
1399: FROM pay_assignment_actions paa
1400: ,pay_payroll_actions ppa

Line 1406: from per_all_assignments_f paaf, per_assignment_extra_info paei

1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl
1404: WHERE paaf.person_id=c_person_id
1405: AND paa.assignment_id in (select paaf.assignment_id
1406: from per_all_assignments_f paaf, per_assignment_extra_info paei
1407: where paaf.person_id = c_person_id
1408: and paaf.assignment_id=paei.assignment_id
1409: and paei.information_type = 'IE_ASG_OVERRIDE'
1410: and paei.aei_information1 = c_ppsn_override --'314678745T'

Line 1422: l_ppsn_override per_assignment_extra_info.aei_information1%type;

1418: AND scl.segment4 = to_char(g_employer_id)
1419: AND to_char(ppa.effective_date,'yyyy')=to_char(g_year);
1420:
1421:
1422: l_ppsn_override per_assignment_extra_info.aei_information1%type;
1423: /* 9768428 end */
1424:
1425: l_ness_action_details csr_ness_action_details%ROWTYPE;
1426: l_input_value_id NUMBER;