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_ASSIGNMENT_ACTIONS

Line 1007: pay_assignment_actions paa,

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 '
1011: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '

Line 1063: pay_assignment_actions paa,

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 '
1067: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '

Line 1115: SELECT pay_assignment_actions_s.nextval

1111: LOOP
1112: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
1113: FETCH csr_get_asg INTO l_assg_id;
1114: EXIT WHEN csr_get_asg%NOTFOUND;
1115: SELECT pay_assignment_actions_s.nextval
1116: INTO lockingactid
1117: FROM dual;
1118:
1119: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);

Line 1196: CURSOR cur_get_pactid(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS

1192: PROCEDURE archive_data(p_assactid in number,
1193: p_effective_date in date)
1194: IS
1195:
1196: CURSOR cur_get_pactid(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
1197: SELECT distinct paa.payroll_action_id,paa.assignment_id,paaf.person_id,papf.employee_number
1198: FROM pay_assignment_actions paa
1199: ,per_all_assignments_f paaf
1200: ,per_all_people_f papf -- 9795571

Line 1198: FROM pay_assignment_actions paa

1194: IS
1195:
1196: CURSOR cur_get_pactid(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
1197: SELECT distinct paa.payroll_action_id,paa.assignment_id,paaf.person_id,papf.employee_number
1198: FROM pay_assignment_actions paa
1199: ,per_all_assignments_f paaf
1200: ,per_all_people_f papf -- 9795571
1201: WHERE paa.assignment_action_id = p_cess_aact
1202: and paa.assignment_id=paaf.assignment_id

Line 1210: FROM pay_assignment_actions paa

1206: CURSOR cur_assignment_action(c_person_id number,
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

Line 1229: FROM pay_assignment_actions paa

1225:
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

Line 1340: pay_assignment_actions paa

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:
1344: cursor csr_get_periods(c_start_date in date,

Line 1373: FROM pay_assignment_actions paa

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
1375: ,per_all_assignments_f paaf
1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl

Line 1399: FROM pay_assignment_actions paa

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
1401: ,per_all_assignments_f paaf
1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl

Line 3069: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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
3073: action_information1 full_name,

Line 3214: FROM pay_assignment_actions paa,

3210: AND action_information_category ='IE_NES_HEADER';
3211:
3212: CURSOR c_total_sample(c_pact_id NUMBER) IS
3213: SELECT count(*)
3214: FROM pay_assignment_actions paa,
3215: pay_action_information pai
3216: WHERE paa.payroll_action_id=c_pact_id
3217: AND paa.source_action_id is null
3218: AND pai.action_context_id=paa.assignment_action_id