[Home] [Help]
4: -----------------------------------------------------------------------------
5: -- GET_MAIN_TAX_UNIT_ID fetches the Legal Employer Id of the Local Unit
6: -- of the Assignment Id
7: -----------------------------------------------------------------------------
8: g_custom_context pay_action_information.action_information_category%type;
9: g_action_ctx_id NUMBER;
10:
11: PROCEDURE get_main_tax_unit_id
12: (p_assignment_id IN NUMBER
554: AND paa_xfr.assignment_action_id = g_action_ctx_id;
555:
556: l_tag_name varchar2(500);
557: l_chk_no pay_assignment_actions.serial_number%type;
558: l_data pay_action_information.action_information1%type;
559:
560: PROCEDURE LOAD_XML_INTERNAL (
561: P_NODE_TYPE varchar2,
562: P_NODE varchar2,
562: P_NODE varchar2,
563: P_DATA varchar2
564: ) AS
565:
566: l_data pay_action_information.action_information1%type;
567:
568: BEGIN
569:
570: IF p_node_type = 'CS' THEN
635: ,ptp.end_date end_date
636: ,pai.effective_date payment_date
637: FROM per_time_periods ptp
638: ,pay_payrolls_f ppf
639: ,pay_action_information pai
640: WHERE ppf.payroll_id = ptp.payroll_id
641: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
642: AND ptp.time_period_id = pai.action_information16
643: AND pai.action_context_type = 'AAP'
651: ,ptp.end_date end_date
652: ,pai.effective_date payment_date
653: FROM per_time_periods ptp
654: ,pay_payrolls_f ppf
655: ,pay_action_information pai
656: ,pay_assignment_actions paa
657: WHERE ppf.payroll_id = ptp.payroll_id
658: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
659: AND ptp.time_period_id = pai.action_information16
671: ,pai.effective_date payment_date
672: -- ,pai1.action_information4 ss_days
673: FROM per_time_periods ptp
674: ,pay_payrolls_f ppf
675: ,pay_action_information pai
676: -- ,pay_action_information pai1
677: WHERE ppf.payroll_id = ptp.payroll_id
678: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
679: AND ptp.time_period_id = pai.action_information16
672: -- ,pai1.action_information4 ss_days
673: FROM per_time_periods ptp
674: ,pay_payrolls_f ppf
675: ,pay_action_information pai
676: -- ,pay_action_information pai1
677: WHERE ppf.payroll_id = ptp.payroll_id
678: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
679: AND ptp.time_period_id = pai.action_information16
680: AND pai.action_context_type = 'AAP'
701: ,pai.action_information5 type
702: ,pai.action_information6 uom
703: --,pai1.action_information8 record_count
704: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
705: FROM pay_action_information pai
706: ,pay_action_information pai1
707: ,pay_assignment_actions paa
708: WHERE pai.action_context_type = 'PA'
709: AND pai.action_information_category = p_pa_category
702: ,pai.action_information6 uom
703: --,pai1.action_information8 record_count
704: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
705: FROM pay_action_information pai
706: ,pay_action_information pai1
707: ,pay_assignment_actions paa
708: WHERE pai.action_context_type = 'PA'
709: AND pai.action_information_category = p_pa_category
710: AND pai1.action_context_type = 'AAP'
743: ,pai.action_information6 uom
744: --,pai1.action_information8 record_count
745: --,sum(pai1.action_information4) value
746: ,pai1.action_information4 value
747: FROM pay_action_information pai
748: ,pay_action_information pai1
749: ,pay_assignment_actions paa
750: WHERE pai.action_context_type = 'PA'
751: AND pai.action_information_category = p_pa_category
744: --,pai1.action_information8 record_count
745: --,sum(pai1.action_information4) value
746: ,pai1.action_information4 value
747: FROM pay_action_information pai
748: ,pay_action_information pai1
749: ,pay_assignment_actions paa
750: WHERE pai.action_context_type = 'PA'
751: AND pai.action_information_category = p_pa_category
752: AND pai1.action_context_type = 'AAP'