APPS.PAY_KR_YEA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 3778: pay_payroll_actions PACT,

3774: from pay_balance_feeds_f FEED,
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

Line 3780: pay_payroll_actions BACT,

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
3784: and BAL_TYPE.balance_name in ('TOTAL_TAXABLE_EARNINGS', 'TOTAL_NON_TAXABLE_EARNINGS')

Line 4049: from pay_payroll_actions ppa,

4045:
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

Line 5384: pay_payroll_actions ppa,

5380: from pay_report_format_items_f i,
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

Line 5408: from pay_payroll_actions ppa,

5404: select paa.assignment_id,
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: --

Line 5593: pay_payroll_actions ppa,

5589: from dual
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

Line 5609: from pay_payroll_actions ppa,

5605:
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

Line 5621: cursor csr_bal_adj_exists(p_payroll_id pay_payroll_actions.payroll_id%type)

5617: and ppa.report_category IN ('N','I')
5618: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
5619: order by paa.action_sequence desc;
5620:
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

Line 5624: from pay_payroll_actions ppa,

5620:
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

Line 6005: p_business_group_id in pay_payroll_actions.business_group_id%type,

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,
6009: p_itax_adj out nocopy number,

Line 6006: p_effective_date in pay_payroll_actions.effective_date%type,

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,
6009: p_itax_adj out nocopy number,
6010: p_rtax_adj out nocopy number,

Line 6007: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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,
6009: p_itax_adj out nocopy number,
6010: p_rtax_adj out nocopy number,
6011: p_stax_adj out nocopy number,

Line 6031: from pay_payroll_actions ppa

6027: IS
6028: select pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) report_category
6029: ,ppa.element_type_id element_type_id
6030: ,ppa.payroll_id payroll_id
6031: from pay_payroll_actions ppa
6032: where ppa.payroll_action_id = p_payroll_action_id;
6033: -------------------------------------------
6034: r_pact csr_pact%rowtype;
6035: -------------------------------------------