[Home] [Help]
186: AND pai.Action_information1 = to_char(p_gre_id) /* Bug 11698592 */
187: AND pai.action_information3 = p_assessment_year;
188: --
189: l_procedure VARCHAR2(100);
190: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
191: --
192: BEGIN
193: g_debug := hr_utility.debug_enabled;
194: l_procedure := g_package ||'get_max_context_id';
499: p_qtr_end date)
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
514: AND paa.source_action_id IS NULL
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
712: l_pymt_date VARCHAR2(240);
713: l_procedure VARCHAR2(100);
714: l_open_tag VARCHAR2(100);
715: l_last_quarter VARCHAR2(10);
716: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
717:
718:
719: BEGIN
720: g_debug := hr_utility.debug_enabled;
814: -- p_source_id NUMBER --
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
989: -- p_source_id NUMBER --
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)
1257: ,pay_element_entry_values_f value
1258: ,pay_element_links_f links
1259: WHERE assign.assignment_id =
1260: (SELECT assignment_id
1261: FROM pay_assignment_actions
1262: WHERE assignment_action_id = p_action_context_id)
1263: AND links.element_type_id = type.element_type_id
1264: AND links.element_type_id = entries.element_type_id
1265: AND links.element_link_id = entries.element_link_id
1291: WHERE action_information_category ='IN_24Q_DEDUCTEE'
1292: AND action_context_type = 'AAP'
1293: AND action_information3 =p_org_id
1294: AND EXISTS (SELECT 1
1295: FROM pay_assignment_actions paa
1296: WHERE paa.payroll_action_id = p_action_id
1297: AND paa.assignment_action_id = pai.action_context_id
1298: AND paa.assignment_id = p_assignment_id);
1299:
1304: WHERE action_information_category ='IN_24QC_DEDUCTEE'
1305: AND action_context_type = 'AAP'
1306: AND action_information3 =p_org_id
1307: AND EXISTS (SELECT 1
1308: FROM pay_assignment_actions paa
1309: WHERE paa.payroll_action_id = p_action_id
1310: AND paa.assignment_action_id = pai.action_context_id
1311: AND paa.assignment_id = p_assignment_id);
1312:
1984: -- --
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;
2224: AND action_information1 = to_char(p_gre_id)
2225: AND ROWNUM =1;
2226:
2227: l_procedure VARCHAR2(100);
2228: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2229:
2230:
2231: BEGIN
2232: g_debug := hr_utility.debug_enabled;
2291: IS
2292: l_procedure VARCHAR2(100);
2293: l_open_tag VARCHAR2(100);
2294: l_gre_id hr_organization_units.organization_id%TYPE;
2295: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2296: l_emp_number per_people_f.employee_number%TYPE;
2297: l_emp_count NUMBER;
2298: l_start_date DATE;
2299: l_end_date DATE;
2360: AND pai.action_information2 = p_assessment_year
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 );
2548: IS
2549: l_procedure VARCHAR2(100);
2550: l_open_tag VARCHAR2(100);
2551: l_gre_id hr_organization_units.organization_id%TYPE;
2552: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2553: l_emp_number per_people_f.employee_number%TYPE;
2554: l_emp_count NUMBER;
2555: l_start_date DATE;
2556: l_end_date DATE;
2618: AND pai.action_information2 = p_assessment_year
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 );