APPS.PAY_IN_TAX_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 499: from pay_payroll_Actions ppa,

495:
496: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
497: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
498: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
499: from pay_payroll_Actions ppa,
500: pay_assignment_Actions paa,
501: per_assignments_f asg -- Added to remove NMV as per bug 4774108
502: where ppa.payroll_Action_id = paa.payroll_Action_id
503: and paa.assignment_id = p_assignment_id

Line 512: ,pay_payroll_actions ppa1

508: and ppa.date_earned between p_year_start and p_year_end
509: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
510: and paa.action_sequence = ( select max(pac.action_sequence)
511: from pay_assignment_actions pac
512: ,pay_payroll_actions ppa1
513: where pac.assignment_id = paa.assignment_id
514: and pac.payroll_action_id = ppa1.payroll_action_id
515: and ppa1.date_earned between p_year_start and p_year_end
516: and trunc(ppa.date_earned,'MM') = trunc(ppa1.date_earned,'MM')

Line 2206: pay_payroll_actions pa,

2202: )
2203: IS
2204: SELECT ee.element_entry_id
2205: FROM pay_assignment_actions aa,
2206: pay_payroll_actions pa,
2207: pay_element_entries_f ee,
2208: pay_element_links_f el,
2209: pay_element_types_f et,
2210: pay_element_entry_values_f peev

Line 2270: ,pay_payroll_actions ppa

2266: FROM pay_run_results prr
2267: ,pay_run_result_values prrv1
2268: ,pay_run_result_values prrv2
2269: ,pay_assignment_actions paa
2270: ,pay_payroll_actions ppa
2271: where prr.run_result_id =prrv1.run_result_id
2272: and prrv1.input_value_id = p_exempted_id
2273: and prrv2.input_value_id = p_carry_over_id
2274: and prr.run_result_id =prrv2.run_result_id

Line 3324: FROM pay_payroll_Actions ppa

3320: IS
3321:
3322: CURSOR c_max_asact(l_le_end_date DATE) IS
3323: SELECT MAX(paa.assignment_action_id)
3324: FROM pay_payroll_Actions ppa
3325: ,pay_assignment_actions paa
3326: WHERE paa.assignment_id =p_assignment_id
3327: AND paa.payroll_action_id = ppa.payroll_Action_id
3328: AND ppa.action_type in('R','Q')

Line 3558: pay_payroll_actions prev_pay,

3554:
3555: CURSOR c_recent_run_action IS
3556: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
3557: FROM pay_assignment_actions prev_asg,
3558: pay_payroll_actions prev_pay,
3559: per_time_periods ptp,
3560: pay_assignment_actions cur_asg,
3561: pay_payroll_actions cur_pay
3562: WHERE prev_asg.assignment_id = p_assignment_id

Line 3561: pay_payroll_actions cur_pay

3557: FROM pay_assignment_actions prev_asg,
3558: pay_payroll_actions prev_pay,
3559: per_time_periods ptp,
3560: pay_assignment_actions cur_asg,
3561: pay_payroll_actions cur_pay
3562: WHERE prev_asg.assignment_id = p_assignment_id
3563: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id
3564: AND prev_pay.action_type IN('R','Q')
3565: AND prev_asg.source_action_id IS NOT NULL

Line 3658: pay_payroll_actions pact,

3654: IS
3655: CURSOR csr_regular_run IS
3656: SELECT 'Y' FROM
3657: per_time_periods ptp,
3658: pay_payroll_actions pact,
3659: pay_assignment_actions assact,
3660: pay_payroll_actions bact,
3661: pay_assignment_actions bal_assact,
3662: pay_run_types_f prt

Line 3660: pay_payroll_actions bact,

3656: SELECT 'Y' FROM
3657: per_time_periods ptp,
3658: pay_payroll_actions pact,
3659: pay_assignment_actions assact,
3660: pay_payroll_actions bact,
3661: pay_assignment_actions bal_assact,
3662: pay_run_types_f prt
3663: WHERE bal_assact.assignment_action_id = p_assignment_action_id
3664: AND bal_assact.payroll_action_id = bact.payroll_action_id