APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_TIME_PERIODS

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 991: FROM per_time_periods ptp,

987: l_pay_holiday_rule VARCHAR2(80);
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