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 PER_ALL_ASSIGNMENTS_F

Line 60: FROM per_all_assignments_f asg

56: CURSOR csr_get_max_asg_end_date(p_asg_id NUMBER,
57: p_date DATE,
58: p_date_mask VARCHAR2) IS
59: SELECT MAX(asg.effective_end_date)
60: FROM per_all_assignments_f asg
61: WHERE asg.assignment_id = p_asg_id
62: AND asg.payroll_id IS NOT NULL
63: AND asg.effective_end_date BETWEEN TRUNC(p_date, p_date_mask)
64: AND p_date;

Line 112: FROM per_all_assignments_f asg,

108:
109: CURSOR csr_asg_in_payroll(p_asg_id NUMBER,
110: p_date DATE) IS
111: SELECT 'X'
112: FROM per_all_assignments_f asg,
113: pay_all_payrolls_f pay
114: WHERE asg.assignment_id = p_asg_id
115: AND p_date BETWEEN asg.effective_start_date
116: AND asg.effective_end_date

Line 126: per_all_assignments_f asg

122: p_date DATE,
123: p_date_mask VARCHAR2) IS
124: SELECT MAX(pay.effective_end_date)
125: FROM pay_all_payrolls_f pay,
126: per_all_assignments_f asg
127: WHERE asg.assignment_id = p_asg_id
128: AND asg.payroll_id = pay.payroll_id
129: AND pay.effective_end_date BETWEEN TRUNC(p_date, p_date_mask)
130: AND p_date;

Line 301: per_all_assignments_f asg

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)
304: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)
305: AND ((p_basis_type = 'OTHER'

Line 331: FROM per_all_assignments_f asg,

327: p_src_id NUMBER,
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

Line 375: FROM per_all_assignments_f asg,

371: p_jd VARCHAR2,
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

Line 414: FROM per_all_assignments_f asg,

410: p_jd VARCHAR2,
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,

Line 617: per_all_assignments_f asg

613: p_end_date DATE,
614: p_def_bal_id NUMBER) IS
615: SELECT DISTINCT prb.assignment_action_id
616: FROM pay_run_balances prb,
617: per_all_assignments_f asg
618: WHERE asg.organization_id = NVL(p_org_id, asg.organization_id)
619: AND asg.location_id = NVL(p_loc_id, asg.location_id)
620: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)
621: AND ((p_basis_type = 'OTHER'

Line 651: FROM per_all_assignments_f asg,

647: p_start_date DATE,
648: p_end_date DATE,
649: p_def_bal_id NUMBER) IS
650: SELECT DISTINCT prb.assignment_action_id
651: FROM per_all_assignments_f asg,
652: pay_run_balances prb
653: WHERE prb.source_id = p_src_id
654: AND prb.effective_date BETWEEN p_start_date
655: AND p_end_date

Line 694: FROM per_all_assignments_f asg,

690: p_start_date DATE,
691: p_end_date DATE,
692: p_def_bal_id NUMBER) IS
693: SELECT DISTINCT prb.assignment_action_id
694: FROM per_all_assignments_f asg,
695: pay_run_balances prb
696: WHERE prb.jurisdiction_code = p_jd
697: AND prb.tax_unit_id = p_gre_id
698: AND prb.defined_balance_id = p_def_bal_id

Line 729: FROM per_all_assignments_f asg,

725: p_jd VARCHAR2,
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,

Line 1056: FROM per_all_assignments_f asg

1052: p_gre_id NUMBER,
1053: p_start_date DATE,
1054: p_end_date DATE) IS
1055: SELECT DISTINCT(asg.assignment_id) assignment_id
1056: FROM per_all_assignments_f asg
1057: WHERE asg.organization_id = NVL(p_org_id, asg.organization_id)
1058: AND asg.location_id = NVL(p_loc_id, asg.location_id)
1059: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)
1060: AND ((p_basis_type = 'OTHER'

Line 1089: FROM per_all_assignments_f asg,

1085: p_src_id NUMBER,
1086: p_start_date DATE,
1087: p_end_date DATE) IS
1088: SELECT DISTINCT(acx.assignment_id) assignment_id
1089: FROM per_all_assignments_f asg,
1090: pay_action_contexts acx,
1091: ff_contexts cxt
1092: WHERE cxt.context_name = 'SOURCE_ID'
1093: AND cxt.context_id = acx.context_id

Line 1134: FROM per_all_assignments_f asg,

1130: p_jd VARCHAR2,
1131: p_start_date DATE,
1132: p_end_date DATE) IS
1133: SELECT DISTINCT(asg.assignment_id) assignment_id
1134: FROM per_all_assignments_f asg,
1135: pay_action_contexts acx,
1136: ff_contexts cxt
1137: WHERE cxt.context_name = 'JURISDICTION_CODE'
1138: AND cxt.context_id = acx.context_id

Line 1174: FROM per_all_assignments_f asg,

1170: p_jd VARCHAR2,
1171: p_start_date DATE,
1172: p_end_date DATE) IS
1173: SELECT DISTINCT(acx1.assignment_id) assignment_id
1174: FROM per_all_assignments_f asg,
1175: pay_action_contexts acx2,
1176: pay_action_contexts acx1,
1177: ff_contexts cxt2,
1178: ff_contexts cxt1

Line 1513: FROM per_all_assignments_f asg

1509: p_start_date DATE,
1510: p_end_date DATE,
1511: p_def_bal_id NUMBER) IS
1512: SELECT DISTINCT(asg.assignment_id) assignment_id
1513: FROM per_all_assignments_f asg
1514: WHERE EXISTS (SELECT 'X'
1515: FROM pay_run_balances prb
1516: WHERE prb.assignment_id = asg.assignment_id
1517: AND prb.tax_unit_id = p_gre_id

Line 1599: FROM per_all_assignments_f asg

1595: p_start_date DATE,
1596: p_end_date DATE,
1597: p_def_bal_id NUMBER) IS
1598: SELECT DISTINCT(asg.assignment_id) assignment_id
1599: FROM per_all_assignments_f asg
1600: WHERE asg.organization_id = NVL(p_org_id, asg.organization_id)
1601: AND asg.location_id = NVL(p_loc_id, asg.location_id)
1602: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)
1603: AND ((p_basis_type = 'OTHER'

Line 1635: FROM per_all_assignments_f asg

1631: p_start_date DATE,
1632: p_end_date DATE,
1633: p_def_bal_id NUMBER) IS
1634: SELECT DISTINCT(asg.assignment_id) assignment_id
1635: FROM per_all_assignments_f asg
1636: WHERE EXISTS (SELECT 'X'
1637: FROM pay_run_balances prb
1638: WHERE asg.assignment_id = prb.assignment_id
1639: AND prb.source_id = p_src_id

Line 1680: FROM per_all_assignments_f asg

1676: p_start_date DATE,
1677: p_end_date DATE,
1678: p_def_bal_id NUMBER) IS
1679: SELECT DISTINCT(asg.assignment_id) assignment_id
1680: FROM per_all_assignments_f asg
1681: WHERE EXISTS (SELECT 'X'
1682: FROM pay_run_balances prb
1683: WHERE prb.assignment_id = asg.assignment_id
1684: AND prb.tax_unit_id = p_gre_id

Line 1715: FROM per_all_assignments_f asg,

1711: p_jd VARCHAR2,
1712: p_start_date DATE,
1713: p_end_date DATE) IS
1714: SELECT DISTINCT(acx1.assignment_id) assignment_id
1715: FROM per_all_assignments_f asg,
1716: pay_action_contexts acx2,
1717: pay_action_contexts acx1,
1718: ff_contexts cxt2,
1719: ff_contexts cxt1

Line 2074: FROM per_all_assignments_f asg,

2070: p_gre NUMBER,
2071: p_gre_type VARCHAR2) IS
2072: SELECT asg.assignment_id,
2073: asg.business_group_id
2074: FROM per_all_assignments_f asg,
2075: hr_soft_coding_keyflex sck
2076: WHERE decode(p_gre_type, 'T4A/RL1', sck.segment11, 'T4A/RL2', sck.segment12,
2077: sck.segment1) = TO_CHAR(p_gre)
2078: AND asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id

Line 2121: from pay_run_balances prb,per_all_assignments_f paf

2117: p_end_date DATE,
2118: p_gre NUMBER,
2119: cp_def_bal_id NUMBER) IS
2120: select prb.assignment_id,paf.business_group_id
2121: from pay_run_balances prb,per_all_assignments_f paf
2122: where prb.defined_balance_id = cp_def_bal_id
2123: and prb.tax_unit_id = p_gre
2124: and prb.effective_date between p_start_date AND p_end_date
2125: and prb.assignment_id = paf.assignment_id

Line 2156: per_all_assignments_f asg,

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
2160: WHERE acx.context_value = TO_CHAR(p_src)

Line 2614: FROM per_all_assignments_f asg,

2610: p_gre_type VARCHAR2,
2611: cp_def_bal_id NUMBER) IS
2612: SELECT asg.assignment_id,
2613: asg.business_group_id
2614: FROM per_all_assignments_f asg,
2615: pay_run_balances prb
2616: WHERE prb.defined_balance_id = cp_def_bal_id
2617: and prb.effective_date between p_start_date AND p_end_date
2618: and prb.tax_unit_id = p_gre

Line 2658: from pay_run_balances prb,per_all_assignments_f paf

2654: p_end_date DATE,
2655: p_gre NUMBER,
2656: cp_def_bal_id NUMBER) IS
2657: select prb.assignment_id,paf.business_group_id
2658: from pay_run_balances prb,per_all_assignments_f paf
2659: where prb.defined_balance_id = cp_def_bal_id
2660: and prb.tax_unit_id = p_gre
2661: and prb.effective_date between p_start_date AND p_end_date
2662: and prb.assignment_id = paf.assignment_id

Line 2682: per_all_assignments_f asg

2678: p_src NUMBER,
2679: cp_def_bal_id NUMBER) IS
2680: SELECT prb.assignment_id, asg.business_group_id
2681: FROM pay_run_balances prb,
2682: per_all_assignments_f asg
2683: WHERE prb.defined_balance_id = cp_def_bal_id
2684: and asg.assignment_id = prb.assignment_id
2685: and prb.source_id = TO_CHAR(p_src)
2686: AND asg.organization_id = NVL(p_org_id, asg.organization_id)