[Home] [Help]
3775: pay_balance_types BAL_TYPE,
3776: pay_run_result_values TARGET,
3777: pay_run_results RR,
3778: pay_payroll_actions PACT,
3779: pay_assignment_actions ASSACT,
3780: pay_payroll_actions BACT,
3781: pay_assignment_actions BAL_ASSACT,
3782: pay_run_types_f RTYPE
3783: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
3777: pay_run_results RR,
3778: pay_payroll_actions PACT,
3779: pay_assignment_actions ASSACT,
3780: pay_payroll_actions BACT,
3781: pay_assignment_actions BAL_ASSACT,
3782: pay_run_types_f RTYPE
3783: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
3784: and BAL_TYPE.balance_name in ('TOTAL_TAXABLE_EARNINGS', 'TOTAL_NON_TAXABLE_EARNINGS')
3785: and BAL_TYPE.legislation_code = 'KR'
4046: cursor csr_assact(l_effective_date in date) is
4047: select
4048: paa.assignment_action_id
4049: from pay_payroll_actions ppa,
4050: pay_assignment_actions paa
4051: where paa.assignment_id = p_assignment_id
4052: and paa.source_action_id is null
4053: and ppa.business_group_id = p_business_group_id
4054: and ppa.payroll_id = p_payroll_id
5381: ff_database_items d,
5382: ff_user_entities u,
5383: ff_archive_items a,
5384: pay_payroll_actions ppa,
5385: pay_assignment_actions paa
5386: where paa.assignment_action_id = p_assignment_action_id
5387: and ppa.payroll_action_id = paa.payroll_action_id
5388: and a.context1 = paa.assignment_action_id
5389: and a.value is not null
5405: ppa.effective_date
5406: into l_assignment_id,
5407: l_effective_date
5408: from pay_payroll_actions ppa,
5409: pay_assignment_actions paa
5410: where paa.assignment_action_id = p_assignment_action_id
5411: and ppa.payroll_action_id = paa.payroll_action_id;
5412: --
5413: -- Bulk collect archive items. Bulk collect is for better performance.
5590: where exists(
5591: select null
5592: from pay_action_classifications pac,
5593: pay_payroll_actions ppa,
5594: pay_assignment_actions paa
5595: where paa.assignment_id = p_assignment_id
5596: and paa.action_status not in ('C', 'S') -- Bug 4442484: A 'S'kipped assact is not an errored one
5597: and paa.assignment_action_id <> p_bal_asg_action_id
5598: and paa.source_action_id is null
5606: cursor csr_archive_exists
5607: is
5608: select ppa.effective_date
5609: from pay_payroll_actions ppa,
5610: pay_assignment_actions paa
5611: where paa.assignment_id = p_assignment_id
5612: and ppa.payroll_action_id = paa.payroll_action_id
5613: and paa.source_action_id is null
5614: and ppa.action_type IN ('X','B')
5621: cursor csr_bal_adj_exists(p_payroll_id pay_payroll_actions.payroll_id%type)
5622: is
5623: select ppa.effective_date
5624: from pay_payroll_actions ppa,
5625: pay_assignment_actions paa
5626: where paa.assignment_id = p_assignment_id
5627: and ppa.payroll_action_id = paa.payroll_action_id
5628: and ppa.payroll_id = p_payroll_id -- Bug 5045110
5629: and paa.assignment_action_id <> p_bal_asg_action_id
6000: -- New function added to get the adj amount and feed it to ITAX_ADJ,RTAX_ADJ,STAX_ADJ elements
6001: -- using formula results
6002: ---------------------------------------------------------------------------------------------------------------
6003: function calculate_adjustment(
6004: p_assignment_id in pay_assignment_actions.assignment_id%type,
6005: p_business_group_id in pay_payroll_actions.business_group_id%type,
6006: p_effective_date in pay_payroll_actions.effective_date%type,
6007: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6008: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6004: p_assignment_id in pay_assignment_actions.assignment_id%type,
6005: p_business_group_id in pay_payroll_actions.business_group_id%type,
6006: p_effective_date in pay_payroll_actions.effective_date%type,
6007: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6008: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6009: p_itax_adj out nocopy number,
6010: p_rtax_adj out nocopy number,
6011: p_stax_adj out nocopy number,
6012: p_error out nocopy varchar2