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

Line 21: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

17:
18: /* Procedure to pass all the balance results back in one call from report */
19:
20: procedure get_au_rec_balances
21: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
22: p_registered_employer in NUMBER, --2610141
23: p_gross_earnings out NOCOPY number, /*Bug 3953706*/
24: p_non_taxable_earnings out NOCOPY number,
25: p_pre_tax_deductions out NOCOPY number, /*Bug 3953706*/

Line 115: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

111:
112: /* Procedure to pass all the YTD balance results back in one call from report */
113:
114: procedure get_ytd_au_rec_balances
115: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
116: p_registered_employer in NUMBER, --2610141
117: p_ytd_gross_earnings out NOCOPY number, /*Bug 3953706*/
118: p_ytd_non_taxable_earnings out NOCOPY number,
119: p_ytd_pre_tax_deductions out NOCOPY number, /*Bug 3953706*/

Line 529: pay_assignment_actions paa,

525: from per_people_f pap,
526: per_assignments_f paaf,
527: pay_payroll_actions ppa,
528: pay_payroll_actions ppa1,
529: pay_assignment_actions paa,
530: hr_organization_units hou,
531: per_periods_of_service pps
532: where ppa.payroll_action_id = c_payroll_action_id
533: and paa.assignment_id = paaf.assignment_id

Line 582: pay_assignment_actions paa,

578: from per_people_f pap,
579: per_assignments_f paaf,
580: pay_payroll_actions ppa,
581: pay_payroll_actions ppa1,
582: pay_assignment_actions paa,
583: hr_organization_units hou,
584: per_periods_of_service pps
585: where ppa.payroll_action_id = c_payroll_action_id
586: and paa.assignment_id = paaf.assignment_id

Line 635: pay_assignment_actions paa,

631: from per_people_f pap,
632: per_assignments_f paaf,
633: pay_payroll_actions ppa,
634: pay_payroll_actions ppa1,
635: pay_assignment_actions paa,
636: pay_assignment_actions paa2, /*Bug# 3935471*/
637: per_periods_of_service pps
638: where ppa.payroll_action_id = c_payroll_action_id
639: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/

Line 636: pay_assignment_actions paa2, /Bug# 3935471/

632: per_assignments_f paaf,
633: pay_payroll_actions ppa,
634: pay_payroll_actions ppa1,
635: pay_assignment_actions paa,
636: pay_assignment_actions paa2, /*Bug# 3935471*/
637: per_periods_of_service pps
638: where ppa.payroll_action_id = c_payroll_action_id
639: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/
640: AND paa2.assignment_id = paa.assignment_id

Line 694: pay_assignment_actions paa,

690: from per_people_f pap,
691: per_assignments_f paaf,
692: pay_payroll_actions ppa,
693: pay_payroll_actions ppa1,
694: pay_assignment_actions paa,
695: pay_assignment_actions paa2, /*Bug# 3935471*/
696: per_periods_of_service pps
697: where ppa.payroll_action_id = c_payroll_action_id
698: and paa.assignment_id = paaf.assignment_id

Line 695: pay_assignment_actions paa2, /Bug# 3935471/

691: per_assignments_f paaf,
692: pay_payroll_actions ppa,
693: pay_payroll_actions ppa1,
694: pay_assignment_actions paa,
695: pay_assignment_actions paa2, /*Bug# 3935471*/
696: per_periods_of_service pps
697: where ppa.payroll_action_id = c_payroll_action_id
698: and paa.assignment_id = paaf.assignment_id
699: AND paa2.assignment_id = paa.assignment_id /*Bug# 3935471*/

Line 743: pay_assignment_actions paa,

739: from per_people_f pap,
740: per_assignments_f paaf,
741: pay_payroll_actions ppa,
742: pay_payroll_actions ppa1,
743: pay_assignment_actions paa,
744: per_periods_of_service pps
745: where ppa.payroll_action_id = c_payroll_action_id
746: and paa.assignment_id = paaf.assignment_id
747: and pap.person_id between c_start_person and c_end_person

Line 793: pay_assignment_actions paa,

789: from per_people_f pap,
790: per_assignments_f paaf,
791: pay_payroll_actions ppa,
792: pay_payroll_actions ppa1,
793: pay_assignment_actions paa,
794: per_periods_of_service pps
795: where ppa.payroll_action_id = c_payroll_action_id
796: and paa.assignment_id = paaf.assignment_id
797: and pap.person_id between c_start_person and c_end_person

Line 839: pay_assignment_actions paa,

835: from per_people_f pap,
836: per_assignments_f paaf,
837: pay_payroll_actions ppa,
838: pay_payroll_actions ppa1,
839: pay_assignment_actions paa,
840: per_periods_of_service pps
841: where ppa.payroll_action_id = c_payroll_action_id
842: and paa.assignment_id = paaf.assignment_id
843: and pap.person_id between c_start_person and c_end_person

Line 888: pay_assignment_actions paa,

884: from per_people_f pap,
885: per_assignments_f paaf,
886: pay_payroll_actions ppa,
887: pay_payroll_actions ppa1,
888: pay_assignment_actions paa,
889: per_periods_of_service pps
890: where ppa.payroll_action_id = c_payroll_action_id
891: and paa.assignment_id = paaf.assignment_id
892: and pap.person_id between c_start_person and c_end_person

Line 932: pay_assignment_actions paa,

928: from per_people_f pap,
929: per_assignments_f paaf,
930: pay_payroll_actions ppa,
931: pay_payroll_actions ppa1,
932: pay_assignment_actions paa,
933: per_periods_of_service pps
934: where ppa.payroll_action_id = c_payroll_action_id
935: and paa.assignment_id = paaf.assignment_id
936: and pap.person_id between c_start_person and c_end_person

Line 979: pay_assignment_actions paa,

975: from per_people_f pap,
976: per_assignments_f paaf,
977: pay_payroll_actions ppa,
978: pay_payroll_actions ppa1,
979: pay_assignment_actions paa,
980: per_periods_of_service pps
981: where ppa.payroll_action_id = c_payroll_action_id
982: and paa.assignment_id = paaf.assignment_id
983: and pap.person_id between c_start_person and c_end_person

Line 1044: select pay_assignment_actions_s.nextval

1040: ppa.payroll_action_id = c_payroll_action_id;
1041:
1042:
1043: cursor csr_next_action_id is
1044: select pay_assignment_actions_s.nextval
1045: from dual;
1046:
1047: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1048: l_procedure varchar2(200) ;

Line 1047: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1043: cursor csr_next_action_id is
1044: select pay_assignment_actions_s.nextval
1045: from dual;
1046:
1047: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1048: l_procedure varchar2(200) ;
1049: i number;
1050:
1051: l_action_information_id number;

Line 1739: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1735: raise;
1736: end assignment_action_code;
1737:
1738: procedure archive_code
1739: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1740: ,p_effective_date in pay_payroll_actions.effective_date%type
1741: ) is
1742:
1743: /* Bug 3873942

Line 1814: from pay_assignment_actions paa

1810: c_tax_unit_id number)
1811: is
1812: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1813: ,max(paa.action_sequence)
1814: from pay_assignment_actions paa
1815: , pay_payroll_actions ppa
1816: , per_assignments_f paf
1817: where paa.assignment_id = paf.assignment_id
1818: and paf.assignment_id = c_assignment_id

Line 1834: from pay_assignment_actions paa

1830: c_tax_unit_id number)
1831: is
1832: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
1833: ,max(paa.action_sequence)
1834: from pay_assignment_actions paa
1835: , pay_payroll_actions ppa
1836: , per_assignments_f paf
1837: where paa.assignment_id = paf.assignment_id
1838: and paf.assignment_id = c_assignment_id