[Home] [Help]
1929: --Declaration for Payroll - Starts here
1930: p_leg_code varchar2(20);
1931: p_assignment_id per_all_assignments_f.assignment_id%type;
1932: p_assg_action_id pay_assignment_actions.assignment_action_id%type;
1933: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;
1934:
1935: cursor csr_leg_code(p_bus_grp_id number) is
1936: select to_char(org_information9) from
1937: hr_organization_information where organization_id = p_bus_grp_id
1951: ppa.payroll_action_id
1952: ,paa.assignment_id
1953: ,paa.assignment_action_id
1954: , paf.location_id
1955: from pay_payroll_actions ppa
1956: ,pay_assignment_actions paa
1957: ,per_assignments_f paf
1958: ,per_people_f ppf
1959: ,hr_lookups hl
1966: and paa.assignment_id = paf.assignment_id
1967: and paf.person_id = ppf.person_id
1968: and ppf.person_id = p_person_id
1969: and ppa.effective_date = (select max(ppa1.effective_date)
1970: from pay_payroll_actions ppa1
1971: ,pay_assignment_actions paa1
1972: ,hr_lookups hl1
1973: where ppa1.effective_date <= p_eff_date
1974: and ppa1.action_type = 'X'
2147:
2148: -- cursor to fetch the run type
2149: cursor csr_run_type(p_assignment_id number,p_eff_date date) is
2150: select prtf.run_type_name
2151: from pay_payroll_actions ppa,
2152: pay_assignment_actions paa,
2153: pay_run_types_f prtf
2154: where paa.assignment_action_id in (SELECT /*+ USE_NL(paa, pact, ptp) */
2155: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2154: where paa.assignment_action_id in (SELECT /*+ USE_NL(paa, pact, ptp) */
2155: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2156: paa.assignment_action_id),16)) assignment_action_id
2157: FROM pay_assignment_actions paa,
2158: pay_payroll_actions pact
2159: WHERE paa.assignment_id = p_assignment_id
2160: AND paa.payroll_action_id = pact.payroll_action_id
2161: AND pact.action_type IN ('Q','R','B','I','V')
2162: AND paa.action_status = 'C'
2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2174: FROM pay_action_interlocks lck, -- archive action locking prepayment
2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2180: pay_assignment_actions paa, -- payroll run/quickpay action
2181: pay_payroll_actions ppa1, -- payroll run/quickpay action
2177: pay_payroll_actions ppa, -- prepayment
2178: pay_action_information pai, -- archived element/input value definition
2179: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2180: pay_assignment_actions paa, -- payroll run/quickpay action
2181: pay_payroll_actions ppa1, -- payroll run/quickpay action
2182: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2183: pay_input_values_f piv, -- "Pay values" of type Money
2184: pay_run_results prr, -- run result created by the payroll run/quick pay
2185: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2218: FROM pay_action_interlocks lck, -- archive action locking prepayment
2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2224: pay_assignment_actions paa, -- payroll run/quickpay action
2225: pay_payroll_actions ppa1, -- payroll run/quickpay action
2221: pay_payroll_actions ppa, -- prepayment
2222: pay_action_information pai, -- archived element/input value definition
2223: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2224: pay_assignment_actions paa, -- payroll run/quickpay action
2225: pay_payroll_actions ppa1, -- payroll run/quickpay action
2226: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2227: pay_input_values_f piv, -- "Pay values" of type Money
2228: pay_run_results prr, -- run result created by the payroll run/quick pay
2229: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2263: FROM pay_action_interlocks lck, -- archive action locking prepayment
2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2269: pay_assignment_actions paa, -- payroll run/quickpay action
2270: pay_payroll_actions ppa1, -- payroll run/quickpay action
2266: pay_payroll_actions ppa, -- prepayment
2267: pay_action_information pai, -- archived element/input value definition
2268: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
2269: pay_assignment_actions paa, -- payroll run/quickpay action
2270: pay_payroll_actions ppa1, -- payroll run/quickpay action
2271: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2272: pay_input_values_f piv, -- "Pay values" of type Money
2273: pay_run_results prr, -- run result created by the payroll run/quick pay
2274: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
2349: SELECT /*+ USE_NL(paa, pact, ptp) */
2350: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2351: paa.assignment_action_id),16)) assignment_action_id
2352: FROM pay_assignment_actions paa,
2353: pay_payroll_actions pact
2354: WHERE paa.assignment_id = p_assignment_id --16986
2355: AND paa.payroll_action_id = pact.payroll_action_id
2356: AND pact.action_type IN ('Q','R','B','I','V')
2357: AND paa.action_status = 'C'