APPS.PAY_IE_BIK dependencies on PER_TIME_PERIODS

Line 46: , per_time_periods TPERIOD

42:
43: cursor c_first_period_start_date(l_payroll_action_id NUMBER) is
44: select min(TPERIOD.start_date)
45: from pay_payroll_actions PACTION
46: , per_time_periods TPERIOD
47: , per_time_period_types TPTYPE
48: where PACTION.payroll_action_id = l_payroll_action_id
49: and TPERIOD.payroll_id = PACTION.payroll_id
50: and TPTYPE.period_type = TPERIOD.period_type

Line 88: , per_time_periods ptp

84: return date is
85: cursor csr_least_date is
86: select ptp.end_date
87: from pay_payroll_actions ppa
88: , per_time_periods ptp
89: WHERE ppa.payroll_action_id=p_payroll_action_id
90: AND ptp.payroll_id=ppa.payroll_id
91: AND ppa.DATE_EARNED between ptp.start_date and ptp.end_date;
92:

Line 124: , per_time_periods ptp

120: cursor get_end_date(c_minimum_end_date in date) is
121: select ptp.end_date end_date
122: from
123: pay_payroll_actions ppa
124: , per_time_periods ptp
125: , per_time_period_types tptype
126: WHERE ppa.payroll_action_id=p_payroll_action_id
127: AND ptp.payroll_id=ppa.payroll_id
128: AND ptp.period_type = tptype.period_type

Line 137: , per_time_periods ptp

133: c_end_date in date) is
134: select count(ptp.period_num) pay_periods
135: from
136: pay_payroll_actions ppa
137: , per_time_periods ptp
138: , per_time_period_types tptype
139: WHERE ppa.payroll_action_id=p_payroll_action_id
140: AND ptp.payroll_id=ppa.payroll_id
141: AND ptp.period_type = tptype.period_type

Line 150: , per_time_periods ptp

146: cursor get_cumulative_periods(c_maximum_start_date in date,c_end_date in date) is
147: select count(ptp.period_num) pay_periods
148: from
149: pay_payroll_actions ppa
150: , per_time_periods ptp
151: , per_time_period_types tptype
152: WHERE ppa.payroll_action_id=p_payroll_action_id
153: AND ptp.payroll_id=ppa.payroll_id
154: AND ptp.period_type = tptype.period_type