APPS.PAY_NL_TAX_PKG dependencies on PER_TIME_PERIODS

Line 20: ,per_time_periods TPERIOD

16: From
17: per_assignment_extra_info TARGET
18: ,pay_assignment_actions PAA
19: ,pay_payroll_actions PACT
20: ,per_time_periods TPERIOD
21: where PAA.assignment_action_id = p_assignment_action_id
22: AND target.information_type = c_flex_context
23: AND target.assignment_id = PAA.assignment_id
24: AND PAA.payroll_action_id = PACT.payroll_action_id

Line 37: ,per_time_periods TPERIOD

33: From
34: per_assignment_extra_info TARGET
35: ,pay_assignment_actions PAA
36: ,pay_payroll_actions PACT
37: ,per_time_periods TPERIOD
38: where PAA.assignment_action_id = p_assignment_action_id
39: AND target.information_type = c_flex_context
40: AND target.assignment_id = PAA.assignment_id
41: AND PAA.payroll_action_id = PACT.payroll_action_id

Line 135: FROM per_time_periods ptp

131: --
132: CURSOR get_period_dates IS
133: SELECT ptp.start_date start_date
134: ,ptp.end_date end_date
135: FROM per_time_periods ptp
136: WHERE ptp.payroll_id=p_payroll_id
137: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
138: --
139: -- Cursor get_db

Line 210: FROM per_time_periods ptp

206: --
207: CURSOR get_period_dates IS
208: SELECT ptp.start_date start_date
209: ,ptp.end_date end_date
210: FROM per_time_periods ptp
211: WHERE ptp.payroll_id=p_payroll_id
212: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
213: --
214: -- Cursor get_db

Line 290: FROM per_time_periods ptp

286: --
287: CURSOR get_period_dates IS
288: SELECT ptp.start_date start_date
289: ,ptp.end_date end_date
290: FROM per_time_periods ptp
291: WHERE ptp.payroll_id=p_payroll_id
292: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
293: --
294: -- Cursor get_db

Line 347: FROM per_time_periods ptp

343: --
344: CURSOR get_period_dates IS
345: SELECT ptp.start_date start_date
346: ,ptp.end_date end_date
347: FROM per_time_periods ptp
348: WHERE ptp.payroll_id=p_payroll_id
349: AND p_date_earned BETWEEN ptp.start_date AND ptp.end_date;
350: --
351: -- Cursor get_db

Line 905: FROM per_time_periods ptp

901: --
902: CURSOR get_period_dates IS
903: SELECT ptp.start_date start_date
904: ,ptp.end_date end_date
905: FROM per_time_periods ptp
906: WHERE ptp.payroll_id=p_payroll_id
907: AND l_date_paid BETWEEN ptp.start_date AND ptp.end_date;
908: --
909: -- Cursor get_db