APPS.PAY_IE_BIK dependencies on PER_TIME_PERIOD_TYPES

Line 47: , per_time_period_types TPTYPE

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
51: and to_char(PACTION.DATE_EARNED,'YYYY')=to_char(TPERIOD.END_DATE,'YYYY');

Line 125: , per_time_period_types tptype

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
129: AND c_minimum_end_date between PTP.start_date and PTP.end_date;

Line 138: , per_time_period_types tptype

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
142: AND ptp.end_date between

Line 151: , per_time_period_types tptype

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
155: AND ptp.end_date between