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_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 299: FROM pay_payroll_actions pya,

295: p_gre_id NUMBER,
296: p_start_date DATE,
297: p_end_date DATE) IS
298: SELECT DISTINCT asa.assignment_action_id
299: FROM pay_payroll_actions pya,
300: pay_assignment_actions asa,
301: per_all_assignments_f asg
302: WHERE asg.organization_id = NVL(p_org_id, asg.organization_id)
303: AND asg.location_id = NVL(p_loc_id, asg.location_id)

Line 332: pay_payroll_actions pya,

328: p_start_date DATE,
329: p_end_date DATE) IS
330: SELECT DISTINCT asa.assignment_action_id
331: FROM per_all_assignments_f asg,
332: pay_payroll_actions pya,
333: pay_assignment_actions asa,
334: pay_action_contexts acx,
335: ff_contexts cxt
336: WHERE cxt.context_name = 'SOURCE_ID'

Line 376: pay_payroll_actions pya,

372: p_start_date DATE,
373: p_end_date DATE) IS
374: SELECT DISTINCT asa.assignment_action_id
375: FROM per_all_assignments_f asg,
376: pay_payroll_actions pya,
377: pay_assignment_actions asa,
378: pay_action_contexts acx,
379: ff_contexts cxt
380: WHERE cxt.context_name = 'JURISDICTION_CODE'

Line 415: pay_payroll_actions pya,

411: p_start_date DATE,
412: p_end_date DATE) IS
413: SELECT DISTINCT asa.assignment_action_id
414: FROM per_all_assignments_f asg,
415: pay_payroll_actions pya,
416: pay_assignment_actions asa,
417: pay_action_contexts acx2,
418: ff_contexts cxt2,
419: pay_action_contexts acx1,

Line 730: pay_payroll_actions pya,

726: p_start_date DATE,
727: p_end_date DATE) IS
728: SELECT DISTINCT asa.assignment_action_id
729: FROM per_all_assignments_f asg,
730: pay_payroll_actions pya,
731: pay_assignment_actions asa,
732: pay_action_contexts acx2,
733: ff_contexts cxt2,
734: pay_action_contexts acx1,

Line 946: FROM pay_payroll_actions pya,

942: p_end_date DATE) IS
943: SELECT 'X'
944: FROM SYS.DUAL
945: WHERE EXISTS (SELECT 'X'
946: FROM pay_payroll_actions pya,
947: pay_assignment_actions asa,
948: pay_assignment_latest_balances alb
949: WHERE alb.assignment_id = p_asg_id
950: AND alb.defined_balance_id = p_def_bal_id

Line 968: FROM pay_payroll_actions pya,

964: p_end_date DATE) IS
965: SELECT DISTINCT(asg.assignment_id) assignment_id
966: FROM per_all_assignments asg
967: WHERE EXISTS (SELECT 'X'
968: FROM pay_payroll_actions pya,
969: pay_assignment_actions asa
970: WHERE asa.assignment_id = asg.assignment_id
971: AND asa.tax_unit_id = p_gre_id
972: AND pya.payroll_action_id = asa.payroll_action_id

Line 986: FROM pay_payroll_actions pya,

982: WHERE cxt.context_name = 'SOURCE_ID'
983: AND cxt.context_id = acx.context_id
984: AND acx.context_value = TO_CHAR(p_src_id)
985: AND EXISTS (SELECT 'X'
986: FROM pay_payroll_actions pya,
987: pay_assignment_actions asa
988: WHERE asa.assignment_action_id = acx.assignment_action_id
989: AND pya.payroll_action_id = asa.payroll_action_id
990: AND pya.effective_date BETWEEN p_start_date

Line 1010: FROM pay_payroll_actions pya,

1006: WHERE cxt.context_name = 'JURISDICTION_CODE'
1007: AND cxt.context_id = acx.context_id
1008: AND acx.context_value = p_jd
1009: AND EXISTS (SELECT 'X'
1010: FROM pay_payroll_actions pya,
1011: pay_assignment_actions asa
1012: WHERE asa.assignment_action_id = acx.assignment_action_id
1013: AND asa.tax_unit_id = p_gre_id
1014: AND pya.payroll_action_id = asa.payroll_action_id

Line 1035: FROM pay_payroll_actions pya,

1031: AND cxt2.context_id = acx2.context_id
1032: AND acx2.context_value = p_jd
1033: AND acx1.assignment_action_id = acx2.assignment_action_id
1034: AND EXISTS (SELECT 'X'
1035: FROM pay_payroll_actions pya,
1036: pay_assignment_actions asa
1037: WHERE asa.assignment_action_id = acx1.assignment_action_id
1038: AND pya.payroll_action_id = asa.payroll_action_id
1039: AND pya.effective_date BETWEEN p_start_date

Line 1073: FROM pay_payroll_actions pya,

1069: WHERE pyb.pay_basis IN
1070: ('ANNUAL','MONTHLY','PERIOD')))
1071: OR (p_basis_type IS NULL))
1072: AND EXISTS (SELECT 'X'
1073: FROM pay_payroll_actions pya,
1074: pay_assignment_actions asa
1075: WHERE asa.assignment_id = asg.assignment_id
1076: AND asa.tax_unit_id = p_gre_id
1077: AND pya.payroll_action_id = asa.payroll_action_id

Line 1096: FROM pay_payroll_actions pya,

1092: WHERE cxt.context_name = 'SOURCE_ID'
1093: AND cxt.context_id = acx.context_id
1094: AND acx.context_value = TO_CHAR(p_src_id)
1095: AND EXISTS (SELECT 'X'
1096: FROM pay_payroll_actions pya,
1097: pay_assignment_actions asa
1098: WHERE asa.assignment_action_id = acx.assignment_action_id
1099: AND pya.payroll_action_id = asa.payroll_action_id
1100: AND pya.effective_date BETWEEN p_start_date

Line 1141: FROM pay_payroll_actions pya,

1137: WHERE cxt.context_name = 'JURISDICTION_CODE'
1138: AND cxt.context_id = acx.context_id
1139: AND acx.context_value = p_jd
1140: AND EXISTS (SELECT 'X'
1141: FROM pay_payroll_actions pya,
1142: pay_assignment_actions asa
1143: WHERE acx.assignment_action_id = asa.assignment_action_id
1144: AND asa.tax_unit_id = p_gre_id
1145: AND pya.payroll_action_id = asa.payroll_action_id

Line 1189: FROM pay_payroll_actions pya,

1185: AND acx2.context_value = p_jd
1186: AND acx2.assignment_id = asg.assignment_id
1187: AND acx1.assignment_action_id = acx2.assignment_action_id
1188: AND EXISTS (SELECT 'X'
1189: FROM pay_payroll_actions pya,
1190: pay_assignment_actions asa
1191: WHERE asa.assignment_action_id = acx1.assignment_action_id
1192: AND asa.tax_unit_id = p_gre_id
1193: AND pya.payroll_action_id = asa.payroll_action_id

Line 1489: FROM pay_payroll_actions pya,

1485: p_end_date DATE) IS
1486: SELECT 'X'
1487: FROM SYS.DUAL
1488: WHERE EXISTS (SELECT 'X'
1489: FROM pay_payroll_actions pya,
1490: pay_assignment_actions asa,
1491: pay_assignment_latest_balances alb
1492: WHERE alb.assignment_id = p_asg_id
1493: AND alb.defined_balance_id = p_def_bal_id

Line 1574: FROM pay_payroll_actions pya,

1570: AND cxt2.context_id = acx2.context_id
1571: AND acx2.context_value = p_jd
1572: AND acx1.assignment_action_id = acx2.assignment_action_id
1573: AND EXISTS (SELECT 'X'
1574: FROM pay_payroll_actions pya,
1575: pay_assignment_actions asa
1576: WHERE asa.assignment_action_id = acx1.assignment_action_id
1577: AND pya.payroll_action_id = asa.payroll_action_id
1578: AND pya.effective_date BETWEEN p_start_date

Line 1730: FROM pay_payroll_actions pya,

1726: AND acx2.context_value = p_jd
1727: AND acx2.assignment_id = asg.assignment_id
1728: AND acx1.assignment_action_id = acx2.assignment_action_id
1729: AND EXISTS (SELECT 'X'
1730: FROM pay_payroll_actions pya,
1731: pay_assignment_actions asa
1732: WHERE asa.assignment_action_id = acx1.assignment_action_id
1733: AND asa.tax_unit_id = p_gre_id
1734: AND pya.payroll_action_id = asa.payroll_action_id

Line 2081: pay_payroll_actions pya

2077: sck.segment1) = TO_CHAR(p_gre)
2078: AND asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
2079: AND EXISTS(SELECT 'X'
2080: FROM pay_assignment_actions asa,
2081: pay_payroll_actions pya
2082: WHERE asa.tax_unit_id = p_gre
2083: AND asg.assignment_id = asa.assignment_id
2084: AND pya.payroll_action_id = asa.payroll_action_id
2085: AND pya.effective_date BETWEEN p_start_date

Line 2134: FROM pay_payroll_actions pya,

2130: CURSOR csr_asg_exists_for_gre_only ( p_start_date DATE,
2131: p_end_date DATE,
2132: p_gre NUMBER) IS
2133: SELECT asa.assignment_id,pya.business_group_id
2134: FROM pay_payroll_actions pya,
2135: pay_assignment_actions asa
2136: WHERE asa.tax_unit_id = p_gre
2137: AND pya.payroll_action_id = asa.payroll_action_id
2138: AND pya.effective_date BETWEEN p_start_date

Line 2155: FROM pay_payroll_actions pya,

2151: p_end_date DATE,
2152: p_src NUMBER) IS
2153: SELECT asg.assignment_id,
2154: asg.business_group_id
2155: FROM pay_payroll_actions pya,
2156: per_all_assignments_f asg,
2157: pay_assignment_actions asa,
2158: pay_action_contexts acx,
2159: ff_contexts cxt