APPS.PAY_IN_TAX_UTILS dependencies on PAY_PAYROLL_ACTIONS

Line 810: from pay_payroll_Actions ppa,

806:
807: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
808: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
809: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
810: from pay_payroll_Actions ppa,
811: pay_assignment_Actions paa,
812: per_assignments_f asg -- Added to remove NMV as per bug 4774108
813: where ppa.payroll_Action_id = paa.payroll_Action_id
814: and paa.assignment_id = p_assignment_id

Line 823: ,pay_payroll_actions ppa1

819: and ppa.date_earned between p_year_start and p_year_end
820: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
821: and paa.action_sequence = ( select max(pac.action_sequence)
822: from pay_assignment_actions pac
823: ,pay_payroll_actions ppa1
824: where pac.assignment_id = paa.assignment_id
825: and pac.payroll_action_id = ppa1.payroll_action_id
826: and ppa1.date_earned between p_year_start and p_year_end
827: and trunc(ppa.date_earned,'MM') = trunc(ppa1.date_earned,'MM')

Line 2641: pay_payroll_actions pa,

2637: )
2638: IS
2639: SELECT ee.element_entry_id
2640: FROM pay_assignment_actions aa,
2641: pay_payroll_actions pa,
2642: pay_element_entries_f ee,
2643: pay_element_links_f el,
2644: pay_element_types_f et,
2645: pay_element_entry_values_f peev

Line 2706: ,pay_payroll_actions ppa

2702: FROM pay_run_results prr
2703: ,pay_run_result_values prrv1
2704: ,pay_run_result_values prrv2
2705: ,pay_assignment_actions paa
2706: ,pay_payroll_actions ppa
2707: where prr.run_result_id =prrv1.run_result_id
2708: and prrv1.input_value_id = p_exempted_id
2709: and prrv2.input_value_id = p_carry_over_id
2710: and prr.run_result_id =prrv2.run_result_id

Line 4377: FROM pay_payroll_Actions ppa

4373: IS
4374:
4375: CURSOR c_max_asact(l_le_end_date DATE) IS
4376: SELECT MAX(paa.assignment_action_id)
4377: FROM pay_payroll_Actions ppa
4378: ,pay_assignment_actions paa
4379: WHERE paa.assignment_id =p_assignment_id
4380: AND paa.payroll_action_id = ppa.payroll_Action_id
4381: AND ppa.action_type in('R','Q')

Line 4611: pay_payroll_actions prev_pay,

4607:
4608: CURSOR c_recent_run_action IS
4609: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
4610: FROM pay_assignment_actions prev_asg,
4611: pay_payroll_actions prev_pay,
4612: per_time_periods ptp,
4613: pay_assignment_actions cur_asg,
4614: pay_payroll_actions cur_pay
4615: WHERE prev_asg.assignment_id = p_assignment_id

Line 4614: pay_payroll_actions cur_pay

4610: FROM pay_assignment_actions prev_asg,
4611: pay_payroll_actions prev_pay,
4612: per_time_periods ptp,
4613: pay_assignment_actions cur_asg,
4614: pay_payroll_actions cur_pay
4615: WHERE prev_asg.assignment_id = p_assignment_id
4616: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id
4617: AND prev_pay.action_type IN('R','Q')
4618: AND prev_asg.source_action_id IS NOT NULL

Line 4711: pay_payroll_actions pact,

4707: IS
4708: CURSOR csr_regular_run IS
4709: SELECT 'Y' FROM
4710: per_time_periods ptp,
4711: pay_payroll_actions pact,
4712: pay_assignment_actions assact,
4713: pay_payroll_actions bact,
4714: pay_assignment_actions bal_assact,
4715: pay_run_types_f prt

Line 4713: pay_payroll_actions bact,

4709: SELECT 'Y' FROM
4710: per_time_periods ptp,
4711: pay_payroll_actions pact,
4712: pay_assignment_actions assact,
4713: pay_payroll_actions bact,
4714: pay_assignment_actions bal_assact,
4715: pay_run_types_f prt
4716: WHERE bal_assact.assignment_action_id = p_assignment_action_id
4717: AND bal_assact.payroll_action_id = bact.payroll_action_id