APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_PAYROLL_ACTIONS

Line 619: FROM per_time_periods ptp , pay_payroll_actions ppa

615: ,p_reduced_rule OUT NOCOPY VARCHAR2) return varchar2 IS
616: l_reduced_rule varchar2(80);
617: cursor c_get_rule (l_pact_id number , l_payroll_id number) IS
618: SELECT ptp.prd_information1
619: FROM per_time_periods ptp , pay_payroll_actions ppa
620: WHERE ppa.payroll_action_id = l_pact_id
621: AND ppa.action_type in ('Q','R')
622: AND ppa.time_period_id = ptp.time_period_id
623: AND ptp.payroll_id = l_payroll_id;

Line 803: ,pay_payroll_actions ppa

799: FROM pay_element_entries_f pee
800: ,pay_element_entry_values_f eev
801: ,pay_input_values_f piv
802: ,pay_element_types_f pet
803: ,pay_payroll_actions ppa
804: WHERE ppa.payroll_action_id = pay_act_id
805: AND pee.assignment_id = p_asg_id
806: AND pet.element_name = 'Employer Contribution Information'
807: AND pet.legislation_code = 'NO'

Line 824: pay_payroll_actions ppa ,

820: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
821: SELECT ORG_INFORMATION6 lu_tax_mun
822: FROM pay_assignment_actions assact ,
823: per_all_assignments_f paa ,
824: pay_payroll_actions ppa ,
825: hr_soft_coding_keyflex scl ,
826: hr_organization_information hoi
827: WHERE assact.assignment_action_id = p_assignment_action_id
828: AND ppa.payroll_action_id = assact.payroll_action_id

Line 992: pay_payroll_actions ppa

988:
989: CURSOR csr_get_pay_holiday_rule (l_pact_id NUMBER, l_payroll_id NUMBER) IS
990: SELECT ptp.prd_information2
991: FROM per_time_periods ptp,
992: pay_payroll_actions ppa
993: WHERE ppa.payroll_action_id = l_pact_id
994: AND ppa.action_type IN('Q','R')
995: AND ppa.time_period_id = ptp.time_period_id
996: AND ptp.payroll_id = l_payroll_id ;