APPS.PSP_MATRIX_DRIVER3_PKG dependencies on PER_TIME_PERIODS

Line 55: from PER_TIME_PERIODS

51: Begin
52: Select to_char(Period_Num) , /* to_char(Start_Date, 'YYYY') Bug fix 1901631 */
53: substr(period_name, instr(period_name, ' ', 1, 1) + 1, 4)
54: into v_period_num, v_start_date
55: from PER_TIME_PERIODS
56: where Start_Date = st_Date
57: and Payroll_ID = v_Payroll_ID;
58: Exception
59: when OTHERS Then

Line 88: from PER_TIME_PERIODS a

84: user desired period.
85: **************************************************/
86: cursor C1 is
87: Select a.time_period_id, a.start_date
88: from PER_TIME_PERIODS a
89: where a.payroll_id = p_payroll_id
90: and (a.start_date >= st_date and a.end_date <= en_date)
91: order by a.start_date;
92:

Line 105: from PER_TIME_PERIODS a

101: BEGIN
102:
103: Select count(*)
104: into n_Start_Date_Match
105: from PER_TIME_PERIODS a
106: where a.START_DATE = st_date
107: and a.payroll_id = p_payroll_id;
108:
109: Select count(*)

Line 111: from PER_TIME_PERIODS a

107: and a.payroll_id = p_payroll_id;
108:
109: Select count(*)
110: into n_End_Date_Match
111: from PER_TIME_PERIODS a
112: where a.END_DATE = en_date
113: and a.payroll_id = p_payroll_id;
114:
115: Open C1;

Line 124: from PER_TIME_PERIODS a

120: If NOT(b_Calculated_First_Period) AND n_Start_Date_Match = 0 Then
121: Begin
122: Select a.START_DATE
123: into n_First_Date
124: from PER_TIME_PERIODS a
125: where a.PAYROLL_ID = p_payroll_id
126: and a.TIME_PERIOD_ID = C1_Row.Time_Period_ID - 1;
127: dat(i) := n_First_Date;
128: b_Calculated_First_Period := TRUE;

Line 145: from PER_TIME_PERIODS a

141: -- the last period's Start Date
142: Begin
143: Select a.START_DATE
144: into n_Last_Date
145: from PER_TIME_PERIODS a
146: where a.PAYROLL_ID = p_payroll_id
147: and a.TIME_PERIOD_ID = C1_Row.Time_Period_ID + 1;
148: dat(i) := n_Last_Date;
149: Exception

Line 163: from PER_TIME_PERIODS a

159: -- where the pay period does not equal to the User-Start-Date-Pay-Period
160: Begin
161: Select a.START_DATE
162: into n_First_Date
163: from PER_TIME_PERIODS a
164: where a.PAYROLL_ID = p_payroll_id
165: and st_date between a.START_DATE and a.END_DATE;
166: dat(i) := n_First_Date;
167: i := i+1;

Line 176: from PER_TIME_PERIODS a

172:
173: Begin
174: Select a.START_DATE
175: into n_Last_Date
176: from PER_TIME_PERIODS a
177: where a.PAYROLL_ID = p_payroll_id
178: and en_date between a.START_DATE and a.END_DATE
179: and a.START_DATE <> n_First_Date;
180: dat(i) := n_Last_Date;

Line 201: from PER_TIME_PERIODS

197: v_payroll_id := get_payroll_id;
198:
199: Select END_DATE
200: into ret_Val
201: from PER_TIME_PERIODS
202: where PAYROLL_ID = v_Payroll_ID
203: and START_DATE = st_date;
204:
205: return ret_Val;