[Home] [Help]
458: act1.assignment_action_id prepaid_action_id
459: FROM pay_payroll_actions ppa,
460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,
465: per_all_assignments_f as1
466: WHERE ppa.payroll_action_id = p_payroll_action_id
459: FROM pay_payroll_actions ppa,
460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,
465: per_all_assignments_f as1
466: WHERE ppa.payroll_action_id = p_payroll_action_id
467: AND appa.consolidation_set_id = p_consolidation_id
482: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
483:
484: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
485: FROM pay_action_interlocks pai1,
486: pay_assignment_actions act2,
487: pay_payroll_actions appa3
488: WHERE pai1.locked_action_id = act.assignment_action_id
489: AND act2.assignment_action_id= pai1.locking_action_id
490: AND act2.payroll_action_id = appa3.payroll_action_id
493: AND appa3.report_type = 'PYDKARCHIVE')
494:
495: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
496: FROM pay_action_interlocks pai1,
497: pay_assignment_actions act2,
498: pay_payroll_actions appa3
499: WHERE pai1.locked_action_id = act.assignment_action_id
500: AND act2.assignment_action_id= pai1.locking_action_id
501: AND act2.payroll_action_id = appa3.payroll_action_id
556: ,l_canonical_end_date) LOOP
557:
558: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
559:
560: SELECT pay_assignment_actions_s.NEXTVAL
561: INTO l_actid
562: FROM dual;
563: --
564: g_index_assact := g_index_assact + 1;
600: CURSOR csr_prepay_id IS
601: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
602: ,run_payact.date_earned date_earned
603: FROM pay_action_interlocks archive_intlck
604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
603: FROM pay_action_interlocks archive_intlck
604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
609: ,pay_assignment_actions archive_assact
610: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
611: and archive_assact.payroll_action_id = p_payroll_action_id
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
609: ,pay_assignment_actions archive_assact
610: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
611: and archive_assact.payroll_action_id = p_payroll_action_id
612: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
613: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
625: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
626: ,run_payact.date_earned date_earned
627: ,run_payact.payroll_action_id run_payact_id
628: FROM pay_action_interlocks archive_intlck
629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
628: FROM pay_action_interlocks archive_intlck
629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
634: ,pay_assignment_actions archive_assact
635: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
636: and archive_assact.payroll_action_id = p_payroll_action_id
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
634: ,pay_assignment_actions archive_assact
635: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
636: and archive_assact.payroll_action_id = p_payroll_action_id
637: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
638: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
1652: pop.org_payment_method_name opm_name,
1653: ppttl.payment_type_name pay_type,
1654: ppp.value value
1655: FROM pay_org_payment_methods_f pop,
1656: pay_assignment_actions paa,
1657: pay_payment_types ppt,
1658: pay_payment_types_tl ppttl,
1659: pay_pre_payments ppp
1660: WHERE paa.assignment_action_id = p_prepay_assact_id
1679: ppp.value value
1680: FROM pay_external_accounts pea,
1681: pay_org_payment_methods_f pop,
1682: pay_personal_payment_methods_f ppm,
1683: pay_assignment_actions paa,
1684: pay_payment_types ppt,
1685: pay_payment_types_tl ppttl,
1686: pay_pre_payments ppp
1687: WHERE
1883: FROM pay_accrual_plans pap
1884: ,pay_element_types_f pet
1885: ,pay_element_links_f pel
1886: ,pay_element_entries_f pee
1887: ,pay_assignment_actions paa
1888: ,pay_payroll_actions ppa
1889: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1890: AND pel.element_type_id = pet.element_type_id
1891: AND pee.element_link_id = pel.element_link_id
2044: ,p_assignment_action_id NUMBER) IS
2045: SELECT rrv.result_value,rr.element_entry_id
2046: FROM pay_run_result_values rrv
2047: ,pay_run_results rr
2048: ,pay_assignment_actions paa
2049: ,pay_payroll_actions ppa
2050: WHERE rrv.input_value_id = p_iv_id
2051: AND rr.element_type_id = p_ele_type_id
2052: AND rr.run_result_id = rrv.run_result_id
2065: ,p_EE_ID NUMBER) IS
2066: SELECT rrv.result_value
2067: FROM pay_run_result_values rrv
2068: ,pay_run_results rr
2069: ,pay_assignment_actions paa
2070: ,pay_payroll_actions ppa
2071: WHERE rrv.input_value_id = p_iv_id
2072: AND rr.element_type_id = p_ele_type_id
2073: AND rr.run_result_id = rrv.run_result_id
2099: ,count(rrv.RUN_RESULT_ID) record_count
2100: ,rrv.result_value UNIT_PRICE
2101: FROM pay_run_result_values rrv
2102: ,pay_run_results rr
2103: ,pay_assignment_actions paa
2104: ,pay_payroll_actions ppa
2105: WHERE rrv.input_value_id = p_iv_id
2106: AND rr.element_type_id = p_ele_type_id
2107: AND rr.run_result_id = rrv.run_result_id
2126: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
2128: FROM pay_run_result_values rrv1
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa
2131: ,pay_payroll_actions ppa
2132: ,pay_run_result_values rrv2
2133: ,pay_run_results rr2
2134: ,pay_run_result_values rrv3
2161: ) IS
2162: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
2163: FROM pay_run_result_values rrv1
2164: ,pay_run_results rr1
2165: ,pay_assignment_actions paa
2166: ,pay_payroll_actions ppa
2167: ,pay_run_result_values rrv2
2168: ,pay_run_results rr2
2169: ,pay_run_result_values rrv3
2590: -----------------
2591: /* Cursor to retrieve Tax Unit Id for setting context */
2592: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2593: SELECT paa.tax_unit_id
2594: FROM pay_assignment_actions paa
2595: WHERE paa.assignment_action_id = p_run_assact_id;
2596: -----------------
2597: /* Cursor to fetch defined balance id */
2598: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2836: ,run_assact.assignment_action_id run_assact_id
2837: ,run_payact.payroll_action_id run_payact_id
2838: ,run_payact.payroll_id payroll_id
2839: FROM pay_action_interlocks archive_intlck
2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact
2844: ,pay_payroll_actions run_payact
2839: FROM pay_action_interlocks archive_intlck
2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact
2844: ,pay_payroll_actions run_payact
2845: WHERE archive_intlck.locking_action_id = p_locking_action_id
2846: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2847: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
2861: ppa.effective_date effective_date,
2862: ptp.start_date start_date
2863: FROM per_time_periods ptp
2864: ,pay_payroll_actions ppa
2865: ,pay_assignment_actions paa
2866: WHERE ptp.payroll_id =ppa.payroll_id
2867: AND ppa.payroll_action_id =paa.payroll_action_id
2868: AND paa.assignment_action_id =p_assact_id
2869: AND ppa.payroll_action_id =p_pay_act_id
2871: -----------------
2872: /* Cursor to retrieve Archive Payroll Action Id */
2873: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2874: SELECT payroll_action_id
2875: FROM pay_assignment_actions
2876: WHERE assignment_Action_id = p_assignment_action_id;
2877: -----------------
2878: l_archive_payact_id NUMBER;
2879: l_record_count NUMBER;
3709: /* Added for Pension changes */
3710: , rr.run_result_id run_result_id
3711: FROM pay_run_result_values rrv
3712: ,pay_run_results rr
3713: ,pay_assignment_actions paa
3714: ,pay_payroll_actions ppa
3715: WHERE rrv.input_value_id = p_iv_id
3716: AND rr.element_type_id = p_ele_type_id
3717: AND rr.run_result_id = rrv.run_result_id
3783: ,p_EE_ID NUMBER) IS
3784: SELECT rrv.result_value
3785: FROM pay_run_result_values rrv
3786: ,pay_run_results rr
3787: ,pay_assignment_actions paa
3788: ,pay_payroll_actions ppa
3789: WHERE rrv.input_value_id = p_iv_id
3790: AND rr.element_type_id = p_ele_type_id
3791: AND rr.run_result_id = rrv.run_result_id
3806: ,count(rrv.RUN_RESULT_ID) record_count
3807: ,rrv.result_value UNIT_PRICE
3808: FROM pay_run_result_values rrv
3809: ,pay_run_results rr
3810: ,pay_assignment_actions paa
3811: ,pay_payroll_actions ppa
3812: WHERE rrv.input_value_id = p_iv_id
3813: AND rr.element_type_id = p_ele_type_id
3814: AND rr.run_result_id = rrv.run_result_id
3833: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
3835: FROM pay_run_result_values rrv1
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa
3838: ,pay_payroll_actions ppa
3839: ,pay_run_result_values rrv2
3840: ,pay_run_results rr2
3841: ,pay_run_result_values rrv3
3869: rrv1.result_value UNIT,
3870: rrv2.result_value AMOUNT
3871: FROM pay_run_result_values rrv1
3872: ,pay_run_results rr1
3873: ,pay_assignment_actions paa
3874: ,pay_payroll_actions ppa
3875: ,pay_run_result_values rrv2
3876: ,pay_run_results rr2
3877: ,pay_run_result_values rrv3