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 412: pay_assignment_actions paa,

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

Line 581: SELECT pay_assignment_actions_s.nextval

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

Line 585: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

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

Line 657: SELECT pay_assignment_actions_s.nextval

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

Line 662: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

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

Line 803: pay_assignment_actions paac

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

Line 839: pay_assignment_actions ppaa,

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

Line 873: pay_assignment_actions paac

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