[Home] [Help]
373: ,pay_v.narrative earn_element
374: ,pay_v.numeric_value earn_value
375: ,pai_ele.action_information7
376: FROM pay_action_information pai_ele
377: ,pay_emea_paymnts_action_info_v pay_v
378: ,pay_assignment_actions paa
379: WHERE paa.assignment_action_id = l_assact_id
380: AND paa.payroll_action_id = pai_ele.action_context_id
381: AND pai_ele.action_context_type = 'PA'
419: ,pay_v.narrative ded_element
420: ,pay_v.numeric_value ded_value
421: ,pai_ele.action_information7
422: FROM pay_action_information pai_ele
423: ,pay_emea_paymnts_action_info_v pay_v
424: ,pay_assignment_actions paa
425: WHERE paa.assignment_action_id= l_assact_id
426: AND paa.payroll_action_id = pai_ele.action_context_id
427: AND pai_ele.action_context_type = 'PA'
488: /* Cursor to get the sum of the Earnings for particular payroll for summary */
489: /*CURSOR csr_get_sum_earn_summary (l_org_name varchar2 , l_payroll_id number , l_effective_date date) IS
490: SELECT sum(pay_v.numeric_value)
491: FROM pay_action_information pai_ele
492: ,pay_emea_paymnts_action_info_v pay_v
493: ,pay_assignment_actions paa
494: WHERE paa.payroll_action_id = pai_ele.action_context_id
495: AND pai_ele.action_context_type = 'PA'
496: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
519: CURSOR csr_get_sum_earn (l_org_structure_version_id number,
520: l_organization_id number , l_payroll_id number , l_effective_date date) IS
521: SELECT sum(pay_v.numeric_value)
522: FROM pay_action_information pai_ele
523: ,pay_emea_paymnts_action_info_v pay_v
524: ,pay_assignment_actions paa
525: WHERE paa.payroll_action_id = pai_ele.action_context_id
526: AND pai_ele.action_context_type = 'PA'
527: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
569: ,pay_action_information pai_emp
570: ,pay_emea_paymnts_action_info_v pay_v
571: WHERE paa.payroll_action_id = pai_ele.action_context_id
572: AND pai_ele.action_context_type = 'PA'
573: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
574: AND pai_ele.action_information7 IN ('E')
615: and ptp.end_date = l_effective_date;
616: CURSOR csr_seoo_split_2 (l_arch_assact number) IS
617: select SUM(pay_v.numeric_value)
618: from pay_action_information pai_ele
619: ,pay_emea_paymnts_action_info_v pay_v
620: ,pay_assignment_actions paa
621: where paa.payroll_action_id = pai_ele.action_context_id
622: and pai_ele.action_context_type = 'PA'
623: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
634: CURSOR csr_get_sum_ded (l_org_structure_version_id number,
635: l_organization_id number , l_payroll_id number , l_effective_date date) IS
636: SELECT sum(pay_v.numeric_value)
637: FROM pay_action_information pai_ele
638: ,pay_emea_paymnts_action_info_v pay_v
639: ,pay_assignment_actions paa
640: WHERE paa.payroll_action_id = pai_ele.action_context_id
641: AND pai_ele.action_context_type = 'PA'
642: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
684: ,pay_action_information pai_emp
685: ,pay_emea_paymnts_action_info_v pay_v
686: WHERE paa.payroll_action_id = pai_ele.action_context_id
687: AND pai_ele.action_context_type = 'PA'
688: AND pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'
689: AND pai_ele.action_information7 IN ('D')
730: and ptp.end_date = l_effective_date;
731: CURSOR csr_sdoo_split_2 (l_arch_assact number) IS
732: select SUM(pay_v.numeric_value)
733: from pay_action_information pai_ele
734: ,pay_emea_paymnts_action_info_v pay_v
735: ,pay_assignment_actions paa
736: where paa.payroll_action_id = pai_ele.action_context_id
737: and pai_ele.action_context_type = 'PA'
738: and pai_ele.action_information_category = 'EMEA ELEMENT DEFINITION'