[Home] [Help]
584: select prrv.result_value
585: from pay_run_results prr,
586: pay_run_result_values prrv,
587: pay_input_values_f piv,
588: pay_assignment_actions paa,
589: pay_payroll_actions ppa
590: where prr.element_type_id + 0 = piv.element_type_id
591: and prr.run_result_id = prrv.run_result_id
592: and prr.source_type = 'E'
606: select prrv.result_value
607: from pay_run_results prr,
608: pay_run_result_values prrv,
609: pay_input_values_f piv,
610: pay_assignment_actions paa,
611: pay_payroll_actions ppa
612: where prr.element_type_id + 0 = piv.element_type_id
613: and prr.run_result_id = prrv.run_result_id
614: and prr.source_type = 'E'
1858: ppp.pre_payment_id,
1859: popm.org_payment_method_id,
1860: popm.org_payment_method_name,
1861: pppm.personal_payment_method_id
1862: from pay_assignment_actions paa,
1863: pay_pre_payments ppp,
1864: pay_org_payment_methods_f popm ,
1865: pay_personal_payment_methods_f pppm,
1866: pay_external_accounts pea
1878: and cp_ppp_source_action_id is null
1879: and exists (
1880: select ''
1881: from pay_run_types_f prt,
1882: pay_assignment_actions paa_run,
1883: pay_payroll_actions ppa_run
1884: where paa_run.assignment_action_id
1885: = ppp.source_action_id
1886: and paa_run.payroll_action_id
2021:
2022: cursor c_child_action (cp_pre_pay_action_id in number
2023: ,cp_assignment_id in number) is
2024: select paa.assignment_action_id
2025: from pay_assignment_actions paa
2026: where paa.source_action_id = cp_pre_pay_action_id
2027: and paa.assignment_id = cp_assignment_id
2028: and paa.action_status = 'C';
2029:
2046: ppp.pre_payment_id,
2047: popm.org_payment_method_id,
2048: popm.org_payment_method_name,
2049: pppm.personal_payment_method_id
2050: from pay_assignment_actions paa,
2051: pay_pre_payments ppp,
2052: pay_org_payment_methods_f popm ,
2053: pay_personal_payment_methods_f pppm,
2054: pay_external_accounts pea
2066: and cp_ppp_source_action_id is null
2067: and exists (
2068: select ''
2069: from pay_run_types_f prt,
2070: pay_assignment_actions paa_run,
2071: pay_payroll_actions ppa_run
2072: where paa_run.assignment_action_id
2073: = ppp.source_action_id
2074: and paa_run.payroll_action_id
2599: select distinct
2600: nvl(pai.tax_unit_id, -1)
2601: ,pai.action_information2 organization_id
2602: from pay_action_information pai
2603: ,pay_assignment_actions paa
2604: where pai.action_information_category = 'EMPLOYEE DETAILS'
2605: and pai.action_context_type = 'AAP'
2606: and pai.action_context_id = paa.assignment_action_id
2607: and paa.payroll_Action_id = cp_payroll_action_id