[Home] [Help]
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)
304: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)
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'
337: AND cxt.context_id = acx.context_id
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'
381: AND cxt.context_id = acx.context_id
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,
420: ff_contexts cxt1
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,
735: ff_contexts cxt1
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
951: AND alb.assignment_action_id = asa.assignment_action_id
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
973: AND pya.effective_date BETWEEN p_start_date
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
991: AND p_end_date);
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
1015: AND pya.effective_date BETWEEN p_start_date
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
1040: AND p_end_date);
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
1078: AND pya.effective_date BETWEEN p_start_date
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
1101: AND p_end_date)
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
1146: AND pya.effective_date BETWEEN p_start_date
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
1194: AND pya.effective_date BETWEEN p_start_date
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
1494: AND alb.assignment_action_id = asa.assignment_action_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
1579: AND p_end_date);
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
1735: AND pya.effective_date BETWEEN p_start_date
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
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
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
2139: AND p_end_date
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)
2161: AND cxt.context_id = acx.context_id
2751: hr_utility.trace('Starting routine: '||l_routine_name);
2752: hr_utility.trace('P_Flag for EBRA: '||p_flag);
2753:
2754: -- Checking the EBRA Flag to use Run Balances cursors or
2755: -- Pay_Assignment_Actions cursors
2756: If p_flag = 'N' then
2757: l_balance_value := ca_group_level_balance(p_balance_name
2758: ,p_time_dimension
2759: ,p_effective_date