[Home] [Help]
282: p_pay_basis_type VARCHAR2,
283: p_business_group_id NUMBER) RETURN NUMBER IS
284:
285: /*
286: * Select all the assignment actions in PAY_ACTION_CONTEXTS for a given GRE
287: * which have been run in a given time period.
288: * These are for the cases where at least one of the additional parameter is
289: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
290: */
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
338: AND acx.context_value = TO_CHAR(p_src_id)
357: ('ANNUAL','MONTHLY','PERIOD')))
358: OR (p_basis_type IS NULL));
359:
360: /*
361: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
362: * jurisdiction which have been run in a given time period.
363: * These are for the cases where at least one of the additional parameter is
364: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
365: */
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
382: AND acx.context_value = p_jd
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
421: WHERE cxt1.context_name = 'SOURCE_ID'
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
421: WHERE cxt1.context_name = 'SOURCE_ID'
422: AND cxt1.context_id = acx1.context_id
423: AND acx1.context_value = TO_CHAR(p_src_id)
595: p_pay_basis_type VARCHAR2,
596: p_business_group_id NUMBER) RETURN NUMBER IS
597:
598: /*
599: * Select all the assignment actions in PAY_ACTION_CONTEXTS for a given GRE
600: * which have been run in a given time period.
601: * These are for the cases where at least one of the additional parameter is
602: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
603: */
672: OR (p_basis_type IS NULL));
673:
674:
675: /*
676: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
677: * jurisdiction which have been run in a given time period.
678: * These are for the cases where at least one of the additional parameter is
679: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
680: */
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
736: WHERE cxt1.context_name = 'SOURCE_ID'
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
736: WHERE cxt1.context_name = 'SOURCE_ID'
737: AND cxt1.context_id = acx1.context_id
738: AND acx1.context_value = TO_CHAR(p_src_id)
953: AND pya.effective_date BETWEEN p_start_date
954: AND p_end_date);
955:
956: /*
957: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE
958: * which have been run in a given time period.
959: * These are for the cases where all the additional parameter ie. location_id,
960: * organization_id, payroll_id, pay_basis_type are NULL
961: */
976: CURSOR csr_get_asg_src(p_src_id NUMBER,
977: p_start_date DATE,
978: p_end_date DATE) IS
979: SELECT DISTINCT(acx.assignment_id) assignment_id
980: FROM pay_action_contexts acx,
981: ff_contexts cxt
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)
990: AND pya.effective_date BETWEEN p_start_date
991: AND p_end_date);
992:
993: /*
994: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
995: * jurisdiction which have been run in a given time period.
996: * These are for the cases where all the additional parameter ie. location_id,
997: * organization_id, payroll_id, pay_basis_type are NULL
998: */
1000: p_jd VARCHAR2,
1001: p_start_date DATE,
1002: p_end_date DATE) IS
1003: SELECT DISTINCT(acx.assignment_id) assignment_id
1004: FROM pay_action_contexts acx,
1005: ff_contexts cxt
1006: WHERE cxt.context_name = 'JURISDICTION_CODE'
1007: AND cxt.context_id = acx.context_id
1008: AND acx.context_value = p_jd
1019: p_jd VARCHAR2,
1020: p_start_date DATE,
1021: p_end_date DATE) IS
1022: SELECT DISTINCT(acx1.assignment_id) assignment_id
1023: FROM pay_action_contexts acx1,
1024: pay_action_contexts acx2,
1025: ff_contexts cxt1,
1026: ff_contexts cxt2
1027: WHERE cxt1.context_name = 'SOURCE_ID'
1020: p_start_date DATE,
1021: p_end_date DATE) IS
1022: SELECT DISTINCT(acx1.assignment_id) assignment_id
1023: FROM pay_action_contexts acx1,
1024: pay_action_contexts acx2,
1025: ff_contexts cxt1,
1026: ff_contexts cxt2
1027: WHERE cxt1.context_name = 'SOURCE_ID'
1028: AND cxt1.context_id = acx1.context_id
1039: AND pya.effective_date BETWEEN p_start_date
1040: AND p_end_date);
1041:
1042: /*
1043: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE
1044: * which have been run in a given time period.
1045: * These are for the cases where at least one of the additional parameter is
1046: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1047: */
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
1094: AND acx.context_value = TO_CHAR(p_src_id)
1116: ('ANNUAL','MONTHLY','PERIOD')))
1117: OR (p_basis_type IS NULL));
1118:
1119: /*
1120: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
1121: * jurisdiction which have been run in a given time period.
1122: * These are for the cases where at least one of the additional parameter is
1123: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1124: */
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
1139: AND acx.context_value = p_jd
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
1179: WHERE cxt1.context_name = 'SOURCE_ID'
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
1179: WHERE cxt1.context_name = 'SOURCE_ID'
1180: AND cxt1.context_id = acx1.context_id
1496: AND pya.effective_date BETWEEN p_start_date
1497: AND p_end_date);
1498:
1499: /*
1500: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE
1501: * which have been run in a given time period.
1502: * These are for the cases where all the additional parameter ie. location_id,
1503: * organization_id, payroll_id, pay_basis_type are NULL
1504: */
1532: AND prb.effective_date BETWEEN p_start_date AND p_end_date;
1533:
1534:
1535: /*
1536: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
1537: * jurisdiction which have been run in a given time period.
1538: * These are for the cases where all the additional parameter ie. location_id,
1539: * organization_id, payroll_id, pay_basis_type are NULL
1540: */
1558: p_jd VARCHAR2,
1559: p_start_date DATE,
1560: p_end_date DATE) IS
1561: SELECT DISTINCT(acx1.assignment_id) assignment_id
1562: FROM pay_action_contexts acx1,
1563: pay_action_contexts acx2,
1564: ff_contexts cxt1,
1565: ff_contexts cxt2
1566: WHERE cxt1.context_name = 'SOURCE_ID'
1559: p_start_date DATE,
1560: p_end_date DATE) IS
1561: SELECT DISTINCT(acx1.assignment_id) assignment_id
1562: FROM pay_action_contexts acx1,
1563: pay_action_contexts acx2,
1564: ff_contexts cxt1,
1565: ff_contexts cxt2
1566: WHERE cxt1.context_name = 'SOURCE_ID'
1567: AND cxt1.context_id = acx1.context_id
1578: AND pya.effective_date BETWEEN p_start_date
1579: AND p_end_date);
1580:
1581: /*
1582: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE
1583: * which have been run in a given time period.
1584: * These are for the cases where at least one of the additional parameter is
1585: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1586: */
1658:
1659:
1660:
1661: /*
1662: * Select all the assignments in PAY_ACTION_CONTEXTS for a given GRE and
1663: * jurisdiction which have been run in a given time period.
1664: * These are for the cases where at least one of the additional parameter is
1665: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1666: */
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
1720: WHERE cxt1.context_name = 'SOURCE_ID'
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
1720: WHERE cxt1.context_name = 'SOURCE_ID'
1721: AND cxt1.context_id = acx1.context_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
2162: AND cxt.context_name = 'SOURCE_ID'