APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_PAYROLL_ACTIONS

Line 597: FROM per_time_periods ptp , pay_payroll_actions ppa

593: ,p_reduced_rule OUT NOCOPY VARCHAR2) return varchar2 IS
594: l_reduced_rule varchar2(80);
595: cursor c_get_rule (l_pact_id number , l_payroll_id number) IS
596: SELECT ptp.prd_information1
597: FROM per_time_periods ptp , pay_payroll_actions ppa
598: WHERE ppa.payroll_action_id = l_pact_id
599: AND ppa.action_type in ('Q','R')
600: AND ppa.time_period_id = ptp.time_period_id
601: AND ptp.payroll_id = l_payroll_id;

Line 781: ,pay_payroll_actions ppa

777: FROM pay_element_entries_f pee
778: ,pay_element_entry_values_f eev
779: ,pay_input_values_f piv
780: ,pay_element_types_f pet
781: ,pay_payroll_actions ppa
782: WHERE ppa.payroll_action_id = pay_act_id
783: AND pee.assignment_id = p_asg_id
784: AND pet.element_name = 'Employer Contribution Information'
785: AND pet.legislation_code = 'NO'

Line 802: pay_payroll_actions ppa ,

798: CURSOR csr_get_lu_tax_mun (p_assignment_action_id NUMBER) IS
799: SELECT ORG_INFORMATION6 lu_tax_mun
800: FROM pay_assignment_actions assact ,
801: per_all_assignments_f paa ,
802: pay_payroll_actions ppa ,
803: hr_soft_coding_keyflex scl ,
804: hr_organization_information hoi
805: WHERE assact.assignment_action_id = p_assignment_action_id
806: AND ppa.payroll_action_id = assact.payroll_action_id

Line 970: pay_payroll_actions ppa

966:
967: CURSOR csr_get_pay_holiday_rule (l_pact_id NUMBER, l_payroll_id NUMBER) IS
968: SELECT ptp.prd_information2
969: FROM per_time_periods ptp,
970: pay_payroll_actions ppa
971: WHERE ppa.payroll_action_id = l_pact_id
972: AND ppa.action_type IN('Q','R')
973: AND ppa.time_period_id = ptp.time_period_id
974: AND ptp.payroll_id = l_payroll_id ;