APPS.PAY_KR_YEA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1397: pay_payroll_actions PACT,

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

Line 1399: pay_payroll_actions BACT,

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

Line 1523: from pay_payroll_actions ppa,

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

Line 2127: pay_payroll_actions ppa,

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

Line 2151: from pay_payroll_actions ppa,

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

Line 2241: pay_payroll_actions ppa,

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

Line 2257: from pay_payroll_actions ppa,

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

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

2265: and ppa.report_category IN ('N','I')
2266: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
2267: order by paa.action_sequence desc;
2268:
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

Line 2272: from pay_payroll_actions ppa,

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

Line 2653: p_business_group_id in pay_payroll_actions.business_group_id%type,

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

Line 2654: p_effective_date in pay_payroll_actions.effective_date%type,

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,
2657: p_itax_adj out nocopy number,
2658: p_rtax_adj out nocopy number,

Line 2655: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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,
2657: p_itax_adj out nocopy number,
2658: p_rtax_adj out nocopy number,
2659: p_stax_adj out nocopy number,

Line 2679: from pay_payroll_actions ppa

2675: IS
2676: select pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) report_category
2677: ,ppa.element_type_id element_type_id
2678: ,ppa.payroll_id payroll_id
2679: from pay_payroll_actions ppa
2680: where ppa.payroll_action_id = p_payroll_action_id;
2681: -------------------------------------------
2682: r_pact csr_pact%rowtype;
2683: -------------------------------------------