[Home] [Help]
377:
378: */
379:
380: FUNCTION check_fw_terminated(p_assignment_id IN per_assignments_f.assignment_id%TYPE
381: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
382: ,p_start_date IN DATE
383: ,p_end_date IN DATE
384: ,p_fw_type IN VARCHAR2
385: ,p_act_term_date OUT NOCOPY per_periods_of_service.actual_termination_date%TYPE)
478:
479: */
480:
481: PROCEDURE get_foreign_worker_dates (p_assignment_id IN per_assignments_f.assignment_id%TYPE
482: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
483: ,p_start_date IN DATE
484: ,p_end_date IN DATE
485: ,p_fw_type IN VARCHAR2
486: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)
759:
760: */
761:
762: FUNCTION is_le_changed(p_assignment_id IN per_assignments_f.assignment_id%TYPE
763: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
764: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
765: ,p_time_period_id IN per_time_periods.time_period_id%TYPE)
766: RETURN VARCHAR2
767: IS
766: RETURN VARCHAR2
767: IS
768:
769: CURSOR other_le_exists(c_assignment_id per_assignments_f.assignment_id%TYPE
770: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
771: ,c_payroll_id per_time_periods.payroll_id%TYPE
772: ,c_time_period_id per_time_periods.time_period_id%TYPE)
773: IS
774: SELECT 'Y'
841:
842: */
843:
844: FUNCTION get_le_changed_prorate_factor(p_assignment_id IN per_assignments_f.assignment_id%TYPE
845: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
846: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
847: ,p_time_period_id IN per_time_periods.time_period_id%TYPE
848: ,p_fw_type IN VARCHAR2
849: )
850: RETURN NUMBER
851: IS
852:
853: CURSOR le_at_period_end(c_assignment_id per_assignments_f.assignment_id%TYPE
854: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
855: ,c_payroll_id per_time_periods.payroll_id%TYPE
856: ,c_time_period_id per_time_periods.time_period_id%TYPE)
857: IS
858: SELECT 'Y'
983:
984: */
985:
986: PROCEDURE get_foreign_payment_amounts(p_assignment_id IN per_assignments_f.assignment_id%TYPE
987: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
988: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates
989: ,p_start_date IN DATE
990: ,p_end_date IN DATE
991: ,p_fw_type IN VARCHAR2
1033: /* Check cost - 13 on hr2rw102 - should be fine! */
1034: CURSOR csr_max_action_id
1035: (c_assignment_id per_assignments_f.assignment_id%TYPE
1036: ,c_time_period_id per_time_periods.time_period_id%TYPE
1037: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1038: ,c_start_date DATE
1039: ,c_end_date DATE
1040: )
1041: IS
1040: )
1041: IS
1042: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1043: -- ,MAX(paa.action_sequence) action_sequence
1044: FROM pay_assignment_actions paa,
1045: pay_payroll_actions ppa,
1046: per_assignments_f paf,
1047: per_time_periods ptp
1048: WHERE paa.assignment_id = paf.assignment_id
1060:
1061: /* Check cost - 13 on hr2rw102 - should be fine! */
1062: CURSOR csr_ytd_max_action_id
1063: (c_assignment_id per_assignments_f.assignment_id%TYPE
1064: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1065: ,c_start_date DATE
1066: ,c_end_date DATE
1067: )
1068: IS
1067: )
1068: IS
1069: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1070: -- ,MAX(paa.action_sequence) action_sequence
1071: FROM pay_assignment_actions paa,
1072: pay_payroll_actions ppa,
1073: per_assignments_f paf
1074: WHERE paa.assignment_id = paf.assignment_id
1075: AND paf.assignment_id = c_assignment_id