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_ZA_COIDA_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 397: pay_assignment_actions paa

393: AND asg.assignment_id = paei.assignment_id
394: AND paei.information_type = 'ZA_SPECIFIC_INFO'
395: AND exists (select 1
396: from pay_payroll_actions ppa,
397: pay_assignment_actions paa
398: where
399: ppa.payroll_id=asg.payroll_id
400: and paa.assignment_id=asg.assignment_id
401: and ppa.time_period_id <=l_end_period_id

Line 442: select pay_assignment_actions_s.nextval

438:
439: prev_asg_id := asgrec.assignment_id;
440:
441: hr_utility.set_location('Creating action for assignment_id '||asgrec.assignment_id, 50);
442: select pay_assignment_actions_s.nextval
443: into lockingactid
444: from dual;
445:
446: -- Insert assignment into pay_assignment_actions

Line 446: -- Insert assignment into pay_assignment_actions

442: select pay_assignment_actions_s.nextval
443: into lockingactid
444: from dual;
445:
446: -- Insert assignment into pay_assignment_actions
447: hr_nonrun_asact.insact
448: (
449: lockingactid,
450: asgrec.assignment_id,

Line 572: , pay_assignment_actions paa2

568: SELECT
569: MAX(paa2.assignment_action_id)
570: FROM
571: pay_run_results prr2
572: , pay_assignment_actions paa2
573: , pay_payroll_actions ppa2
574: WHERE
575: prr2.element_type_id = pet.element_type_id
576: AND prr2.run_result_id = prr2.run_result_id

Line 708: from pay_assignment_actions paa,

704: l_run_assact_id :=0;
705: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,20);
706: select max(paa.action_sequence)
707: into l_run_action_seq
708: from pay_assignment_actions paa,
709: pay_payroll_actions ppa,
710: per_time_periods ptp
711: where paa.assignment_id = p_asg_id
712: and paa.action_status IN ('C','S') --10376999

Line 730: from pay_assignment_actions

726: hr_utility.set_location('l_run_action_seq is not null ' ,30);
727:
728: select assignment_action_id
729: into l_run_assact_id
730: from pay_assignment_actions
731: where assignment_id = p_asg_id
732: and action_sequence = l_run_action_seq;
733:
734: hr_utility.set_location('l_run_assact_id ' || l_run_assact_id,30);

Line 1041: , pay_assignment_actions paa

1037: , nvl(paei.aei_information15,'N') foreign_national
1038: , nvl(paei.aei_information16,'N') exclude_coida -- 12534150
1039: from per_all_people_f per
1040: , per_all_assignments_f asg
1041: , pay_assignment_actions paa
1042: , per_assignment_extra_info paei
1043: , per_person_type_usages_f pptu
1044: , per_person_types ppt
1045: where paa.assignment_action_id = p_assactid

Line 1086: pay_assignment_actions paa

1082: -- Retrieve legislative parameters from the archiver payroll action
1083: select ppa.legislative_parameters, ppa.payroll_action_id
1084: into leg_param , pactid
1085: from pay_payroll_actions ppa,
1086: pay_assignment_actions paa
1087: where paa.assignment_action_id = p_assactid
1088: and ppa.payroll_action_id = paa.payroll_action_id;
1089:
1090:

Line 1192: , pay_assignment_actions paa

1188: select distinct
1189: pai.action_information30 person_id
1190: , pai.action_information9 asg_type
1191: from pay_payroll_actions ppa
1192: , pay_assignment_actions paa
1193: , pay_action_information pai
1194: , pay_assignment_actions paa2
1195: , pay_action_information pai2
1196: where ppa.payroll_action_id = pactid

Line 1194: , pay_assignment_actions paa2

1190: , pai.action_information9 asg_type
1191: from pay_payroll_actions ppa
1192: , pay_assignment_actions paa
1193: , pay_action_information pai
1194: , pay_assignment_actions paa2
1195: , pay_action_information pai2
1196: where ppa.payroll_action_id = pactid
1197: and ppa.action_status = 'C'
1198: and paa.payroll_action_id = ppa.payroll_action_id

Line 1215: pay_assignment_actions paa

1211: --Retrieve the details of duplicate employee records
1212: cursor csr_dup_emp_action_info (l_person_id number, l_asg_type varchar2) is
1213: select pai.*
1214: from pay_action_information pai,
1215: pay_assignment_actions paa
1216: where pai.action_information30 = l_person_id
1217: and pai.action_information9 = l_asg_type
1218: and paa.payroll_action_id = pactid
1219: and paa.assignment_action_id = pai.action_context_id

Line 1242: , pay_assignment_actions paa

1238: , pai.action_information1 mon
1239: , fnd_date.canonical_to_date(pai.action_information10) pay_adv_date --revisit --need to populate this in archive code
1240: , pai.action_information8 num_days
1241: from pay_action_information pai
1242: , pay_assignment_actions paa
1243: , pay_action_information pai2
1244: where pai.action_information30 = l_person_id
1245: and pai.action_information9 = l_asg_type
1246: and paa.assignment_action_id = pai.action_context_id

Line 1272: , pay_assignment_actions paa

1268: , pai2.action_information1 mon
1269: , pai.action_information9 asg_type
1270: from pay_action_information pai --ZA_COID_EMP_INFO
1271: , pay_action_information pai2 --ZA_COID_EMP_INCOME_INFO
1272: , pay_assignment_actions paa
1273: where paa.payroll_action_id = pactid
1274: and paa.assignment_action_id = pai.action_context_id
1275: and pai.action_information_category = 'ZA_COID_EMP_INFO'
1276: and pai2.action_information_category = 'ZA_COID_EMP_INCOME_INFO'