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

Line 409: pay_assignment_actions paa,

405: IS
406: select 'Y'
407: FROM
408: pay_payroll_actions ppa,
409: pay_assignment_actions paa,
410: PAY_ACTION_INFORMATION pai
411: WHERE
412: paa.payroll_action_id = ppa.payroll_action_id
413: AND ppa.action_type = 'X'

Line 578: SELECT pay_assignment_actions_s.nextval

574: END IF; --not submitted online
575: END IF; --THERE R NO ASSG BEFORE
576: IF (l_valid_assg = TRUE) THEN
577: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);
578: SELECT pay_assignment_actions_s.nextval
579: INTO lockingactid
580: FROM dual;
581: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);
582: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

Line 582: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

578: SELECT pay_assignment_actions_s.nextval
579: INTO lockingactid
580: FROM dual;
581: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);
582: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
583: hr_nonrun_asact.insact(lockingactid => lockingactid
584: ,assignid => l_assg_id
585: ,pactid => pactid
586: ,chunk => chunk

Line 654: SELECT pay_assignment_actions_s.nextval

650: --
651:
652: IF (l_valid_assg = TRUE) THEN
653: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);
654: SELECT pay_assignment_actions_s.nextval
655: INTO lockingactid
656: FROM dual;
657:
658: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);

Line 659: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

655: INTO lockingactid
656: FROM dual;
657:
658: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);
659: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
660: hr_nonrun_asact.insact(lockingactid => lockingactid
661: ,assignid => l_assg_id
662: ,pactid => pactid
663: ,chunk => chunk

Line 800: pay_assignment_actions paac

796: pay_input_values_f piv,
797: pay_element_entries_f pee,
798: pay_element_entry_values_f peev,
799: per_all_assignments_f paa,
800: pay_assignment_actions paac
801: WHERE pet.element_name in ('IE P45P3_P46 Information','IE P45 Information')
802: --AND piv.name='P45P3 Or P46 Processed'
803: AND pet.element_type_id=piv.element_type_id
804: AND paa.assignment_id=paac.assignment_id

Line 836: pay_assignment_actions ppaa,

832: FROM per_all_people_f ppf,
833: per_addresses pa,
834: per_all_assignments_f paa,
835: pay_all_payrolls_f pap,
836: pay_assignment_actions ppaa,
837: pa_country_v pc, -- Bug# 7005067
838: fnd_lookup_values flv -- Bug# 7005067
839: WHERE ppaa.assignment_action_id=passactid
840: AND ppaa.assignment_id=paa.assignment_id

Line 870: pay_assignment_actions paac

866: pay_input_values_f piv,
867: pay_element_entries_f pee,
868: pay_element_entry_values_f peev,
869: per_all_assignments_f paa,
870: pay_assignment_actions paac
871: WHERE pet.element_name = 'IE P45P3_P46 Information'
872: AND piv.name='P45P3 Or P46 Processed'
873: AND pet.element_type_id=piv.element_type_id
874: AND paa.assignment_id=paac.assignment_id