[Home] [Help]
712: -- p_rem_pay_period NUMBER --
713: -- p_flag NUMBER --
714: --------------------------------------------------------------------------
715: PROCEDURE build_employee_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
716: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
717: ,p_rem_pay_period OUT NOCOPY NUMBER
718: ,p_flag OUT NOCOPY NUMBER
719: )
720: IS
869: -- p_rem_pay_period NUMBER --
870: -- p_flag NUMBER --
871: --------------------------------------------------------------------------
872: PROCEDURE build_form16_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
873: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
874: ,p_rem_pay_period IN NUMBER
875: ,p_flag IN NUMBER
876: ,p_flag_for_16aa OUT NOCOPY NUMBER)
877: IS
1738: -- Parameters : --
1739: -- IN : p_action_context_id NUMBER --
1740: --------------------------------------------------------------------------
1741: PROCEDURE build_form12ba_xml(p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
1742: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE)
1743: IS
1744: l_total_taxable_perq NUMBER;
1745: l_total_emp_contr NUMBER;
1746:
2011: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2012: AND hou.business_group_id = p_business_group_id
2013: AND EXISTS (SELECT 1
2014: FROM pay_action_information pai,
2015: pay_payroll_actions ppa
2016: WHERE pai.action_information_category = 'IN_EOY_ORG'
2017: AND pai.action_information1 = hou.organization_id
2018: AND pai.action_information3 = p_assessment_year
2019: AND pai.action_context_type ='PA'
2058: AND pai.action_information3 = p_gre_id
2059: AND pai.action_context_id = p_action_context_id
2060: AND EXISTS (SELECT 1
2061: FROM pay_assignment_actions paa
2062: ,pay_payroll_actions ppa
2063: WHERE pai.source_id = paa.assignment_action_id
2064: AND paa.payroll_action_id = ppa.payroll_action_id
2065: AND ppa.business_group_id = p_business_group_id );
2066: