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 86: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

82:
83: /* Procedure to pass all the balance results back in one call from report */
84:
85: procedure get_au_rec_balances
86: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
87: p_registered_employer in NUMBER, --2610141
88: p_gross_earnings out NOCOPY number, /*Bug 3953706*/
89: p_non_taxable_earnings out NOCOPY number,
90: p_pre_tax_deductions out NOCOPY number, /*Bug 3953706*/

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

201:
202: /* Procedure to pass all the YTD balance results back in one call from report */
203:
204: procedure get_ytd_au_rec_balances
205: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
206: p_registered_employer in NUMBER, --2610141
207: p_ytd_gross_earnings out NOCOPY number, /*Bug 3953706*/
208: p_ytd_non_taxable_earnings out NOCOPY number,
209: p_ytd_pre_tax_deductions out NOCOPY number, /*Bug 3953706*/

Line 643: pay_assignment_actions paa,

639: from per_people_f pap,
640: per_assignments_f paaf,
641: pay_payroll_actions ppa,
642: pay_payroll_actions ppa1,
643: pay_assignment_actions paa,
644: hr_organization_units hou,
645: per_periods_of_service pps
646: where ppa.payroll_action_id = c_payroll_action_id
647: and paa.assignment_id = paaf.assignment_id

Line 695: pay_assignment_actions paa,

691: from per_people_f pap,
692: per_assignments_f paaf,
693: pay_payroll_actions ppa,
694: pay_payroll_actions ppa1,
695: pay_assignment_actions paa,
696: hr_organization_units hou,
697: per_periods_of_service pps,
698: pay_population_ranges ppr
699: where ppa.payroll_action_id = c_payroll_action_id

Line 750: pay_assignment_actions paa,

746: from per_people_f pap,
747: per_assignments_f paaf,
748: pay_payroll_actions ppa,
749: pay_payroll_actions ppa1,
750: pay_assignment_actions paa,
751: hr_organization_units hou,
752: per_periods_of_service pps
753: where ppa.payroll_action_id = c_payroll_action_id
754: and paa.assignment_id = paaf.assignment_id

Line 798: pay_assignment_actions paa,

794: from per_people_f pap,
795: per_assignments_f paaf,
796: pay_payroll_actions ppa,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa,
799: hr_organization_units hou,
800: per_periods_of_service pps,
801: pay_population_ranges ppr
802: where ppa.payroll_action_id = c_payroll_action_id

Line 854: pay_assignment_actions paa,

850: from per_people_f pap,
851: per_assignments_f paaf,
852: pay_payroll_actions ppa,
853: pay_payroll_actions ppa1,
854: pay_assignment_actions paa,
855: pay_assignment_actions paa2, /*Bug# 3935471*/
856: per_periods_of_service pps
857: where ppa.payroll_action_id = c_payroll_action_id
858: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/

Line 855: pay_assignment_actions paa2, /Bug# 3935471/

851: per_assignments_f paaf,
852: pay_payroll_actions ppa,
853: pay_payroll_actions ppa1,
854: pay_assignment_actions paa,
855: pay_assignment_actions paa2, /*Bug# 3935471*/
856: per_periods_of_service pps
857: where ppa.payroll_action_id = c_payroll_action_id
858: and paa.assignment_id = paaf.assignment_id /*Bug# 3935471*/
859: AND paa2.assignment_id = paa.assignment_id

Line 912: pay_assignment_actions paa,

908: from per_people_f pap,
909: per_assignments_f paaf,
910: pay_payroll_actions ppa,
911: pay_payroll_actions ppa1,
912: pay_assignment_actions paa,
913: pay_assignment_actions paa2,
914: per_periods_of_service pps,
915: pay_population_ranges ppr
916: where ppa.payroll_action_id = c_payroll_action_id

Line 913: pay_assignment_actions paa2,

909: per_assignments_f paaf,
910: pay_payroll_actions ppa,
911: pay_payroll_actions ppa1,
912: pay_assignment_actions paa,
913: pay_assignment_actions paa2,
914: per_periods_of_service pps,
915: pay_population_ranges ppr
916: where ppa.payroll_action_id = c_payroll_action_id
917: and ppr.payroll_action_id = ppa.payroll_action_id

Line 974: pay_assignment_actions paa,

970: from per_people_f pap,
971: per_assignments_f paaf,
972: pay_payroll_actions ppa,
973: pay_payroll_actions ppa1,
974: pay_assignment_actions paa,
975: pay_assignment_actions paa2, /*Bug# 3935471*/
976: per_periods_of_service pps
977: where ppa.payroll_action_id = c_payroll_action_id
978: and paa.assignment_id = paaf.assignment_id

Line 975: pay_assignment_actions paa2, /Bug# 3935471/

971: per_assignments_f paaf,
972: pay_payroll_actions ppa,
973: pay_payroll_actions ppa1,
974: pay_assignment_actions paa,
975: pay_assignment_actions paa2, /*Bug# 3935471*/
976: per_periods_of_service pps
977: where ppa.payroll_action_id = c_payroll_action_id
978: and paa.assignment_id = paaf.assignment_id
979: AND paa2.assignment_id = paa.assignment_id /*Bug# 3935471*/

Line 1025: pay_assignment_actions paa,

1021: from per_people_f pap,
1022: per_assignments_f paaf,
1023: pay_payroll_actions ppa,
1024: pay_payroll_actions ppa1,
1025: pay_assignment_actions paa,
1026: pay_assignment_actions paa2,
1027: per_periods_of_service pps,
1028: pay_population_ranges ppr
1029: where ppa.payroll_action_id = c_payroll_action_id

Line 1026: pay_assignment_actions paa2,

1022: per_assignments_f paaf,
1023: pay_payroll_actions ppa,
1024: pay_payroll_actions ppa1,
1025: pay_assignment_actions paa,
1026: pay_assignment_actions paa2,
1027: per_periods_of_service pps,
1028: pay_population_ranges ppr
1029: where ppa.payroll_action_id = c_payroll_action_id
1030: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1077: pay_assignment_actions paa,

1073: from per_people_f pap,
1074: per_assignments_f paaf,
1075: pay_payroll_actions ppa,
1076: pay_payroll_actions ppa1,
1077: pay_assignment_actions paa,
1078: per_periods_of_service pps
1079: where ppa.payroll_action_id = c_payroll_action_id
1080: and paa.assignment_id = paaf.assignment_id
1081: and pap.person_id between c_start_person and c_end_person

Line 1131: pay_assignment_actions paa,

1127: pay_population_ranges ppr,
1128: per_people_f pap,
1129: per_assignments_f paaf,
1130: per_periods_of_service pps,
1131: pay_assignment_actions paa,
1132: pay_payroll_actions ppa1
1133: where ppa.payroll_action_id = c_payroll_action_id
1134: and ppr.payroll_action_id = ppa.payroll_action_id
1135: and ppr.chunk_number = c_chunk

Line 1184: pay_assignment_actions paa,

1180: from per_people_f pap,
1181: per_assignments_f paaf,
1182: pay_payroll_actions ppa,
1183: pay_payroll_actions ppa1,
1184: pay_assignment_actions paa,
1185: per_periods_of_service pps
1186: where ppa.payroll_action_id = c_payroll_action_id
1187: and paa.assignment_id = paaf.assignment_id
1188: and pap.person_id between c_start_person and c_end_person

Line 1229: pay_assignment_actions paa,

1225: from per_people_f pap,
1226: per_assignments_f paaf,
1227: pay_payroll_actions ppa,
1228: pay_payroll_actions ppa1,
1229: pay_assignment_actions paa,
1230: per_periods_of_service pps,
1231: pay_population_ranges ppr
1232: where ppa.payroll_action_id = c_payroll_action_id
1233: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1278: pay_assignment_actions paa,

1274: from per_people_f pap,
1275: per_assignments_f paaf,
1276: pay_payroll_actions ppa,
1277: pay_payroll_actions ppa1,
1278: pay_assignment_actions paa,
1279: per_periods_of_service pps
1280: where ppa.payroll_action_id = c_payroll_action_id
1281: and paa.assignment_id = paaf.assignment_id
1282: and pap.person_id between c_start_person and c_end_person

Line 1327: pay_assignment_actions paa,

1323: from per_people_f pap,
1324: per_assignments_f paaf,
1325: pay_payroll_actions ppa,
1326: pay_payroll_actions ppa1,
1327: pay_assignment_actions paa,
1328: per_periods_of_service pps,
1329: pay_population_ranges ppr
1330: where ppa.payroll_action_id = c_payroll_action_id
1331: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1380: pay_assignment_actions paa,

1376: from per_people_f pap,
1377: per_assignments_f paaf,
1378: pay_payroll_actions ppa,
1379: pay_payroll_actions ppa1,
1380: pay_assignment_actions paa,
1381: per_periods_of_service pps
1382: where ppa.payroll_action_id = c_payroll_action_id
1383: and paa.assignment_id = paaf.assignment_id
1384: and pap.person_id between c_start_person and c_end_person

Line 1425: pay_assignment_actions paa,

1421: from per_people_f pap,
1422: per_assignments_f paaf,
1423: pay_payroll_actions ppa,
1424: pay_payroll_actions ppa1,
1425: pay_assignment_actions paa,
1426: per_periods_of_service pps,
1427: pay_population_ranges ppr
1428: where ppa.payroll_action_id = c_payroll_action_id
1429: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1473: pay_assignment_actions paa,

1469: from per_people_f pap,
1470: per_assignments_f paaf,
1471: pay_payroll_actions ppa,
1472: pay_payroll_actions ppa1,
1473: pay_assignment_actions paa,
1474: per_periods_of_service pps
1475: where ppa.payroll_action_id = c_payroll_action_id
1476: and paa.assignment_id = paaf.assignment_id
1477: and pap.person_id between c_start_person and c_end_person

Line 1520: pay_assignment_actions paa,

1516: from per_people_f pap,
1517: per_assignments_f paaf,
1518: pay_payroll_actions ppa,
1519: pay_payroll_actions ppa1,
1520: pay_assignment_actions paa,
1521: per_periods_of_service pps,
1522: pay_population_ranges ppr
1523: where ppa.payroll_action_id = c_payroll_action_id
1524: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1571: pay_assignment_actions paa,

1567: from per_people_f pap,
1568: per_assignments_f paaf,
1569: pay_payroll_actions ppa,
1570: pay_payroll_actions ppa1,
1571: pay_assignment_actions paa,
1572: per_periods_of_service pps
1573: where ppa.payroll_action_id = c_payroll_action_id
1574: and paa.assignment_id = paaf.assignment_id
1575: and pap.person_id between c_start_person and c_end_person

Line 1615: pay_assignment_actions paa,

1611: from per_people_f pap,
1612: per_assignments_f paaf,
1613: pay_payroll_actions ppa,
1614: pay_payroll_actions ppa1,
1615: pay_assignment_actions paa,
1616: per_periods_of_service pps,
1617: pay_population_ranges ppr
1618: where ppa.payroll_action_id = c_payroll_action_id
1619: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1682: select pay_assignment_actions_s.nextval

1678: ppa.payroll_action_id = c_payroll_action_id;
1679:
1680:
1681: cursor csr_next_action_id is
1682: select pay_assignment_actions_s.nextval
1683: from dual;
1684:
1685: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1686: l_procedure varchar2(200) ;

Line 1685: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1681: cursor csr_next_action_id is
1682: select pay_assignment_actions_s.nextval
1683: from dual;
1684:
1685: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1686: l_procedure varchar2(200) ;
1687: i number;
1688:
1689: l_action_information_id number;

Line 3013: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

3009: raise;
3010: end assignment_action_code;
3011:
3012: procedure archive_code
3013: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
3014: ,p_effective_date in pay_payroll_actions.effective_date%type
3015: ) is
3016:
3017: /* Bug 3873942

Line 3088: from pay_assignment_actions paa

3084: c_tax_unit_id number)
3085: is
3086: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
3087: ,max(paa.action_sequence)
3088: from pay_assignment_actions paa
3089: , pay_payroll_actions ppa
3090: , per_assignments_f paf
3091: where paa.assignment_id = paf.assignment_id
3092: and paf.assignment_id = c_assignment_id

Line 3108: from pay_assignment_actions paa

3104: c_tax_unit_id number)
3105: is
3106: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
3107: ,max(paa.action_sequence)
3108: from pay_assignment_actions paa
3109: , pay_payroll_actions ppa
3110: , per_assignments_f paf
3111: where paa.assignment_id = paf.assignment_id
3112: and paf.assignment_id = c_assignment_id