APPS.PAY_NO_HIGH_RATE_TAX dependencies on PER_TIME_PERIODS

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

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