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 PAY_PAYROLL_ACTIONS

Line 282: FROM pay_payroll_actions

278: ) + LENGTH(p_token)
279: )
280: )),
281: TRIM(business_group_id)
282: FROM pay_payroll_actions
283: WHERE payroll_action_id = p_pact_id;
284:
285: l_business_group_id VARCHAR2(300);
286: l_token_value VARCHAR2(300);

Line 316: FROM pay_payroll_actions

312: LENGTH(legislative_parameters)
313: )
314: )
315:
316: FROM pay_payroll_actions
317: WHERE payroll_action_id = p_pact_id;
318:
319:
320: BEGIN

Line 575: FROM pay_payroll_actions

571: l_comments varchar2(300);
572:
573: CURSOR csr_archive_effective_date(pactid NUMBER) IS
574: SELECT effective_date
575: FROM pay_payroll_actions
576: WHERE payroll_action_id = pactid;
577:
578: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
579: ,c_bg_id hr_organization_units.business_group_id%type) IS

Line 664: ' pay_payroll_actions pa' ||

660: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
661:
662: sqlstr := ' select distinct p.person_id' ||
663: ' from per_people_f p,' ||
664: ' pay_payroll_actions pa' ||
665: ' where pa.payroll_action_id = :payroll_action_id' ||
666: ' and p.business_group_id = pa.business_group_id' ||
667: ' order by p.person_id';
668:

Line 1006: pay_payroll_actions ppa,

1002: l_select_str1 :='select count (distinct paaf.assignment_id )
1003: from per_all_assignments_f paaf,
1004: per_all_people_f ppf,
1005: pay_all_payrolls_f papf,
1006: pay_payroll_actions ppa,
1007: pay_assignment_actions paa,
1008: hr_soft_coding_keyflex scl
1009: where paaf.business_group_id = '|| g_business_group_id
1010: ||' and papf.business_group_id = paaf.business_group_id and '

Line 1062: pay_payroll_actions ppa,

1058: || 'select distinct paaf.assignment_id asgid
1059: from per_all_assignments_f paaf,
1060: per_all_people_f ppf,
1061: pay_all_payrolls_f papf,
1062: pay_payroll_actions ppa,
1063: pay_assignment_actions paa,
1064: hr_soft_coding_keyflex scl
1065: where paaf.business_group_id = '|| g_business_group_id
1066: ||' and papf.business_group_id = paaf.business_group_id and '

Line 1144: FROM pay_payroll_actions

1140:
1141:
1142: CURSOR csr_archive_effective_date(pactid NUMBER) IS
1143: SELECT effective_date
1144: FROM pay_payroll_actions
1145: WHERE payroll_action_id = pactid;
1146:
1147: BEGIN
1148:

Line 1211: ,pay_payroll_actions ppa

1207: c_till_date date)is
1208: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1209: paa.assignment_action_id),16))
1210: FROM pay_assignment_actions paa
1211: ,pay_payroll_actions ppa
1212: ,per_all_assignments_f paaf
1213: ,pay_all_payrolls_f papf
1214: ,hr_soft_coding_keyflex scl
1215: WHERE paaf.person_id=c_person_id

Line 1230: ,pay_payroll_actions ppa

1226: CURSOR cur_assignment_action_ytd(c_person_id number)is
1227: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1228: paa.assignment_action_id),16))
1229: FROM pay_assignment_actions paa
1230: ,pay_payroll_actions ppa
1231: ,per_all_assignments_f paaf
1232: ,pay_all_payrolls_f papf
1233: ,hr_soft_coding_keyflex scl
1234: WHERE paaf.person_id=c_person_id

Line 1339: FROM pay_payroll_actions ppa,

1335:
1336: CURSOR csr_ness_action_details(c_assignment_action_id NUMBER) is
1337: SELECT ppa.payroll_action_id pact_id,
1338: ppa.date_earned date_earned
1339: FROM pay_payroll_actions ppa,
1340: pay_assignment_actions paa
1341: WHERE paa.assignment_action_id=c_assignment_action_id
1342: AND paa.payroll_action_id=ppa.payroll_action_id;
1343:

Line 1350: pay_payroll_actions ppa

1346: c_payroll_action_id in number) is
1347: select ptp.period_type period_type,
1348: count(ptp.period_num) pay_periods
1349: from
1350: pay_payroll_actions ppa
1351: , per_time_periods ptp
1352: , per_time_period_types tptype
1353: WHERE ppa.payroll_action_id=c_payroll_action_id
1354: AND ptp.payroll_id=ppa.payroll_id

Line 1374: ,pay_payroll_actions ppa

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
1375: ,per_all_assignments_f paaf
1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl
1378: WHERE paaf.person_id=c_person_id

Line 1400: ,pay_payroll_actions ppa

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
1401: ,per_all_assignments_f paaf
1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl
1404: WHERE paaf.person_id=c_person_id

Line 3068: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

3064: l_proc VARCHAR2(100);
3065:
3066: l_person_id per_all_people_f.person_id%TYPE;
3067: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3068: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3069: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3070:
3071: cursor csr_nes_emp_info (c_pact_id NUMBER) IS
3072: SELECT