[Home] [Help]
500: RETURN NUMBER IS
501: cursor csr_action_id is
502: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
503: FROM pay_assignment_actions paa
504: ,pay_payroll_actions ppa
505: ,per_assignments_f paf
506: WHERE paf.assignment_id = paa.assignment_id
507: AND paf.assignment_id = p_assignment_id
508: AND paa.tax_unit_id = p_tax_unit_id
515: AND (1 = DECODE(ppa.action_type,'I',1,0)
516: OR EXISTS (SELECT ''
517: FROM pay_action_interlocks intk,
518: pay_assignment_actions paa1,
519: pay_payroll_actions ppa1
520: WHERE intk.locked_action_id = paa.assignment_Action_id
521: AND intk.locking_action_id = paa1.assignment_action_id
522: AND paa1.payroll_action_id =ppa1.payroll_action_id
523: AND paa1.assignment_id = p_assignment_id
815: -- p_rem_pay_period NUMBER --
816: -- p_flag NUMBER --
817: --------------------------------------------------------------------------
818: PROCEDURE build_employee_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
819: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
820: ,p_designation IN VARCHAR2
821: ,p_rem_pay_period OUT NOCOPY NUMBER
822: ,p_flag OUT NOCOPY NUMBER
823: )
990: -- p_rem_pay_period NUMBER --
991: -- p_flag NUMBER --
992: --------------------------------------------------------------------------
993: PROCEDURE build_form16_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
994: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
995: ,p_rem_pay_period IN NUMBER
996: ,p_flag IN NUMBER
997: ,p_flag_for_16aa OUT NOCOPY NUMBER)
998: IS
1985: -- Parameters : --
1986: -- IN : p_action_context_id NUMBER --
1987: --------------------------------------------------------------------------
1988: PROCEDURE build_form12ba_xml(p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
1989: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE)
1990: IS
1991: l_total_taxable_perq NUMBER;
1992: l_total_emp_contr NUMBER;
1993:
2314: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2315: AND hou.business_group_id = p_business_group_id
2316: AND EXISTS (SELECT 1
2317: FROM pay_action_information pai,
2318: pay_payroll_actions ppa
2319: WHERE pai.action_information_category = 'IN_EOY_ORG'
2320: AND pai.action_information1 = hou.organization_id
2321: AND pai.action_information3 = p_assessment_year
2322: AND pai.action_context_type ='PA'
2361: AND pai.action_information3 = to_char(p_gre_id) /*Bug 13564801 */
2362: AND pai.action_context_id = p_action_context_id
2363: AND EXISTS (SELECT 1
2364: FROM pay_assignment_actions paa
2365: ,pay_payroll_actions ppa
2366: WHERE pai.source_id = paa.assignment_action_id
2367: AND paa.payroll_action_id = ppa.payroll_action_id
2368: AND ppa.business_group_id = p_business_group_id );
2369:
2571: AND hou.organization_id = NVL(p_gre_id,hou.organization_id)
2572: AND hou.business_group_id = p_business_group_id
2573: AND EXISTS (SELECT 1
2574: FROM pay_action_information pai,
2575: pay_payroll_actions ppa
2576: WHERE pai.action_information_category = 'IN_EOY_ORG'
2577: AND pai.action_information1 = hou.organization_id
2578: AND pai.action_information3 = p_assessment_year
2579: AND pai.action_context_type ='PA'
2619: AND pai.action_information3 = to_char(p_gre_id) /*Bug 13564801 */
2620: AND pai.action_context_id = p_action_context_id
2621: AND EXISTS (SELECT 1
2622: FROM pay_assignment_actions paa
2623: ,pay_payroll_actions ppa
2624: WHERE pai.source_id = paa.assignment_action_id
2625: AND paa.payroll_action_id = ppa.payroll_action_id
2626: AND ppa.business_group_id = p_business_group_id );
2627: