[Home] [Help]
1394: pay_balance_types BAL_TYPE,
1395: pay_run_result_values TARGET,
1396: pay_run_results RR,
1397: pay_payroll_actions PACT,
1398: pay_assignment_actions ASSACT,
1399: pay_payroll_actions BACT,
1400: pay_assignment_actions BAL_ASSACT,
1401: pay_run_types_f RTYPE
1402: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1396: pay_run_results RR,
1397: pay_payroll_actions PACT,
1398: pay_assignment_actions ASSACT,
1399: pay_payroll_actions BACT,
1400: pay_assignment_actions BAL_ASSACT,
1401: pay_run_types_f RTYPE
1402: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1403: and BAL_TYPE.balance_name in ('TOTAL_TAXABLE_EARNINGS', 'TOTAL_NON_TAXABLE_EARNINGS')
1404: and BAL_TYPE.legislation_code = 'KR'
1520: cursor csr_assact is
1521: select
1522: paa.assignment_action_id
1523: from pay_payroll_actions ppa,
1524: pay_assignment_actions paa
1525: where paa.assignment_id = p_assignment_id
1526: and paa.source_action_id is null
1527: and ppa.business_group_id = p_business_group_id
1528: and ppa.payroll_id = p_payroll_id
2124: ff_database_items d,
2125: ff_user_entities u,
2126: ff_archive_items a,
2127: pay_payroll_actions ppa,
2128: pay_assignment_actions paa
2129: where paa.assignment_action_id = p_assignment_action_id
2130: and ppa.payroll_action_id = paa.payroll_action_id
2131: and a.context1 = paa.assignment_action_id
2132: and a.value is not null
2148: ppa.effective_date
2149: into l_assignment_id,
2150: l_effective_date
2151: from pay_payroll_actions ppa,
2152: pay_assignment_actions paa
2153: where paa.assignment_action_id = p_assignment_action_id
2154: and ppa.payroll_action_id = paa.payroll_action_id;
2155: --
2156: -- Bulk collect archive items. Bulk collect is for better performance.
2238: where exists(
2239: select null
2240: from pay_action_classifications pac,
2241: pay_payroll_actions ppa,
2242: pay_assignment_actions paa
2243: where paa.assignment_id = p_assignment_id
2244: and paa.action_status not in ('C', 'S') -- Bug 4442484: A 'S'kipped assact is not an errored one
2245: and paa.assignment_action_id <> p_bal_asg_action_id
2246: and paa.source_action_id is null
2254: cursor csr_archive_exists
2255: is
2256: select ppa.effective_date
2257: from pay_payroll_actions ppa,
2258: pay_assignment_actions paa
2259: where paa.assignment_id = p_assignment_id
2260: and ppa.payroll_action_id = paa.payroll_action_id
2261: and paa.source_action_id is null
2262: and ppa.action_type IN ('X','B')
2269: cursor csr_bal_adj_exists(p_payroll_id pay_payroll_actions.payroll_id%type)
2270: is
2271: select ppa.effective_date
2272: from pay_payroll_actions ppa,
2273: pay_assignment_actions paa
2274: where paa.assignment_id = p_assignment_id
2275: and ppa.payroll_action_id = paa.payroll_action_id
2276: and ppa.payroll_id = p_payroll_id -- Bug 5045110
2277: and paa.assignment_action_id <> p_bal_asg_action_id
2648: -- New function added to get the adj amount and feed it to ITAX_ADJ,RTAX_ADJ,STAX_ADJ elements
2649: -- using formula results
2650: ---------------------------------------------------------------------------------------------------------------
2651: function calculate_adjustment(
2652: p_assignment_id in pay_assignment_actions.assignment_id%type,
2653: p_business_group_id in pay_payroll_actions.business_group_id%type,
2654: p_effective_date in pay_payroll_actions.effective_date%type,
2655: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2656: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2652: p_assignment_id in pay_assignment_actions.assignment_id%type,
2653: p_business_group_id in pay_payroll_actions.business_group_id%type,
2654: p_effective_date in pay_payroll_actions.effective_date%type,
2655: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2656: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2657: p_itax_adj out nocopy number,
2658: p_rtax_adj out nocopy number,
2659: p_stax_adj out nocopy number,
2660: p_error out nocopy varchar2