APPS.PJI_RM_SUM_AVL dependencies on PJI_ROLL_WEEK_OFFSET

Line 123: FROM PJI_ROLL_WEEK_OFFSET;

119: BEGIN
120: --Check if the table is already populated or not
121: SELECT count(*)
122: INTO l_roll_week_offset_cnt
123: FROM PJI_ROLL_WEEK_OFFSET;
124:
125: -- If already populated then return
126: IF (l_roll_week_offset_cnt <> 0 )THEN
127: RETURN;

Line 139: INSERT INTO PJI_ROLL_WEEK_OFFSET

135: FROM PJI_SYSTEM_SETTINGS;
136:
137: FOR i in 1.. l_no_of_roll_week-1
138: LOOP
139: INSERT INTO PJI_ROLL_WEEK_OFFSET
140: (
141: GLOBAL_SEQUENCE_ID,
142: OFFSET
143: )

Line 150: INSERT INTO PJI_ROLL_WEEK_OFFSET

146: i,
147: -(l_no_of_roll_week - i)
148: );
149: END LOOP;
150: INSERT INTO PJI_ROLL_WEEK_OFFSET
151: (
152: GLOBAL_SEQUENCE_ID,
153: OFFSET
154: )

Line 162: INSERT INTO PJI_ROLL_WEEK_OFFSET

158: 0
159: );
160: FOR j in 1.. l_no_of_roll_week-1
161: LOOP
162: INSERT INTO PJI_ROLL_WEEK_OFFSET
163: (
164: GLOBAL_SEQUENCE_ID,
165: OFFSET
166: )

Line 176: tabname => 'PJI_ROLL_WEEK_OFFSET',

172: END LOOP;
173:
174: -- implicit commit
175: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
176: tabname => 'PJI_ROLL_WEEK_OFFSET',
177: percent => 100,
178: degree => 1);
179:
180: COMMIT;

Line 1868: , PJI_ROLL_WEEK_OFFSET rw

1864: , DECODE(sign(g_no_of_roll_week-11),1,1-abs(sign( FLOOR((w.period_id-( (FLOOR(( w.period_id + rw.offset - 11 + g_no_of_roll_week )/g_no_of_roll_week)-1) * g_no_of_roll_week + 11 ))/g_no_of_roll_week) )),null) rw12_flag
1865: , DECODE(sign(g_no_of_roll_week-12),1,1-abs(sign( FLOOR((w.period_id-( (FLOOR(( w.period_id + rw.offset - 12 + g_no_of_roll_week )/g_no_of_roll_week)-1) * g_no_of_roll_week + 12 ))/g_no_of_roll_week) )),null) rw13_flag
1866: FROM
1867: PJI_RM_AGGR_AVL1 w
1868: , PJI_ROLL_WEEK_OFFSET rw
1869: WHERE
1870: w.period_type = 'W'
1871: and w.worker_id = p_worker_id
1872: ) cur5