eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_RDB_POST_RETRIEVAL dependencies on FND_GLOBAL

Line 147: WHERE ret_user_id = FND_GLOBAL.user_id

143: start_time,
144: stop_time,
145: ROWIDTOCHAR(rdb.rowid)
146: FROM hxc_rdb_post_timecards rdb
147: WHERE ret_user_id = FND_GLOBAL.user_id
148: AND old_batch_id IS NOT NULL
149: AND retro_batch_id IS NOT NULL
150: AND NOT EXISTS ( SELECT 1
151: FROM hxc_rdb_post_timecards rdb2

Line 152: WHERE rdb2.ret_user_id = FND_GLOBAL.user_id

148: AND old_batch_id IS NOT NULL
149: AND retro_batch_id IS NOT NULL
150: AND NOT EXISTS ( SELECT 1
151: FROM hxc_rdb_post_timecards rdb2
152: WHERE rdb2.ret_user_id = FND_GLOBAL.user_id
153: AND rdb2.batch_id = rdb.old_batch_id );
154:
155: -- Bug 9705704
156: -- Cursor to pick up unique combo to delete duplicates.

Line 163: WHERE ret_user_id = FND_GLOBAL.user_id

159: timecard_id,
160: NVL(batch_id,'0'),
161: NVL(retro_batch_id,'0')
162: FROM hxc_rdb_post_timecards rdb
163: WHERE ret_user_id = FND_GLOBAL.user_id
164: GROUP BY timecard_id,batch_id,retro_batch_id;
165:
166: tctab NUMBERTAB;
167: statustab VARCHARTAB;

Line 213: FND_GLOBAL.user_id);

209: restab(i),
210: oldtab(i),
211: starttab(i),
212: stoptab(i),
213: FND_GLOBAL.user_id);
214:
215: COMMIT;
216:
217: END LOOP;

Line 227: WHERE ret_user_id = FND_GLOBAL.user_id;

223: -- as batch_id itself.
224:
225: UPDATE hxc_rdb_post_timecards
226: SET old_batch_id = NULL
227: WHERE ret_user_id = FND_GLOBAL.user_id;
228:
229: -- Pick up the unique combos.
230: OPEN get_duplicates;
231: LOOP

Line 243: WHERE ret_user_id = FND_GLOBAL.user_id

239: -- Delete those duplicates which do not have the max
240: -- rowid.
241: FORALL i IN rowtab.FIRST..rowtab.LAST
242: DELETE FROM hxc_rdb_post_timecards
243: WHERE ret_user_id = FND_GLOBAL.user_id
244: AND timecard_id = tctab(i)
245: AND NVL(batch_id,'0') = batchtab(i)
246: AND NVL(retro_batch_id,'0') = rettab(i)
247: AND ROWID <> CHARTOROWID(rowtab(i));

Line 275: WHERE ret_user_id = FND_GLOBAL.user_id;

271: IS SELECT ROWIDTOCHAR(ROWID),
272: RANK() OVER ( PARTITION BY timecard_id
273: ORDER BY TO_NUMBER(approval_status) DESC ) rank
274: FROM hxc_rdb_post_timecards rdb
275: WHERE ret_user_id = FND_GLOBAL.user_id;
276:
277: tctab VARCHARTAB;
278: ovntab NUMBERTAB;
279: ranktab NUMBERTAB;

Line 291: WHERE ret_user_id = FND_GLOBAL.user_id

287: EXIT WHEN tctab.COUNT = 0;
288:
289: FORALL i IN tctab.FIRST..tctab.LAST
290: DELETE FROM hxc_rdb_post_timecards
291: WHERE ret_user_id = FND_GLOBAL.user_id
292: AND ROWID = CHARTOROWID(tctab(i))
293: AND ranktab(i) <> 1 ;
294:
295:

Line 315: WHERE tc.ret_user_id = FND_GLOBAL.user_id

311: asg.job_id,
312: ROWIDTOCHAR(tc.ROWID)
313: FROM hxc_rdb_post_timecards tc,
314: per_assignments_f asg -- Bug 12605349
315: WHERE tc.ret_user_id = FND_GLOBAL.user_id
316: AND tc.resource_id = asg.person_id
317: AND tc.start_time BETWEEN asg.effective_start_date
318: AND asg.effective_end_date;
319:

Line 363: AND rdb.ret_user_id = FND_GLOBAL.user_id;

359: per_people_f ppf -- Bug 12605349
360: WHERE SYSDATE BETWEEN ppf.effective_start_date
361: AND ppf.effective_end_date
362: AND rdb.resource_id = ppf.person_id
363: AND rdb.ret_user_id = FND_GLOBAL.user_id;
364:
365: nametab VARCHARTAB;
366: notab VARCHARTAB;
367: rowtab VARCHARTAB;

Line 492: l_details := REPLACE(l_details,'USERID',FND_GLOBAL.user_id);

488: ELSIF p_application = 'PAY'
489: THEN
490: l_details := REPLACE(l_details,'LATEST_DETAILS','HXC_RET_PAY_LATEST_DETAILS');
491: END IF;
492: l_details := REPLACE(l_details,'USERID',FND_GLOBAL.user_id);
493:
494: OPEN l_ref_cursor FOR l_details;
495: LOOP
496: FETCH l_ref_cursor BULK COLLECT INTO restab,

Line 569: FND_GLOBAL.user_id);

565: rbatchid(i),
566: reqid(i),
567: rreqid(i),
568: obatchid(i),
569: FND_GLOBAL.user_id);
570:
571: COMMIT;
572: END LOOP;
573:

Line 703: l_details := REPLACE(l_details,'USERID',FND_GLOBAL.user_id);

699: ELSIF p_application = 'PAY'
700: THEN
701: l_details := REPLACE(l_details,'LATEST_DETAILS','HXC_RET_PAY_LATEST_DETAILS');
702: END IF;
703: l_details := REPLACE(l_details,'USERID',FND_GLOBAL.user_id);
704:
705: OPEN l_ref_cursor FOR l_details;
706: LOOP
707: FETCH l_ref_cursor BULK COLLECT INTO restab,

Line 780: FND_GLOBAL.user_id);

776: rbatchid(i),
777: reqid(i),
778: rreqid(i),
779: obatchid(i),
780: FND_GLOBAL.user_id);
781:
782: COMMIT;
783: END LOOP;
784:

Line 802: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

798: IS SELECT sum.approval_status,
799: rdb.timecard_id
800: FROM hxc_rdb_post_timecards rdb,
801: hxc_timecard_summary sum
802: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
803: AND rdb.timecard_id = sum.timecard_id;
804:
805:
806: -- To pick up those which are deleted now or overwritten with a

Line 812: WHERE ret_user_id = FND_GLOBAL.user_id

808:
809: CURSOR get_blocks
810: IS SELECT ROWIDTOCHAR(rowid)
811: FROM hxc_rdb_post_timecards
812: WHERE ret_user_id = FND_GLOBAL.user_id
813: AND approval_status NOT IN ( SELECT lookup_code
814: FROM fnd_lookup_values
815: WHERE lookup_type = 'HXC_APPROVAL_STATUS'
816: AND language = USERENV('LANG') );

Line 828: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

824: sum.approval_status,
825: ROWIDTOCHAR(rdb.rowid)
826: FROM hxc_rdb_post_timecards rdb,
827: hxc_timecard_summary sum
828: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
829: AND rdb.approval_status = 'RDBDELETED'
830: AND rdb.resource_id = sum.resource_id
831: AND rdb.start_time = sum.start_time
832: AND rdb.stop_time = TRUNC(sum.stop_time)

Line 860: WHERE ret_user_id = FND_GLOBAL.user_id

856:
857: FORALL i IN tctab.FIRST..tctab.LAST
858: UPDATE hxc_rdb_post_timecards
859: SET approval_status = stattab(i)
860: WHERE ret_user_id = FND_GLOBAL.user_id
861: AND timecard_id = tctab(i);
862:
863: COMMIT;
864: END LOOP;

Line 924: WHERE ret_user_id = FND_GLOBAL.user_id

920:
921: CURSOR pick_timecards
922: IS SELECT ROWIDTOCHAR(rdb.rowid)
923: FROM hxc_rdb_post_timecards rdb
924: WHERE ret_user_id = FND_GLOBAL.user_id
925: AND retro_batch_id IS NOT NULL;
926:
927:
928: CURSOR pick_details

Line 931: WHERE ret_user_id = FND_GLOBAL.user_id

927:
928: CURSOR pick_details
929: IS SELECT ROWIDTOCHAR(rdb.rowid)
930: FROM hxc_rdb_post_details rdb
931: WHERE ret_user_id = FND_GLOBAL.user_id
932: AND retro_batch_id IS NOT NULL;
933:
934: rowtab VARCHARTAB;
935:

Line 976: WHERE tc.ret_user_id = FND_GLOBAL.user_id

972: CURSOR get_partially_retrieved_pay
973: IS SELECT ROWIDTOCHAR(tc.ROWID)
974: FROM hxc_rdb_post_timecards tc,
975: hxc_pay_latest_details pay
976: WHERE tc.ret_user_id = FND_GLOBAL.user_id
977: AND tc.timecard_id = pay.timecard_id;
978:
979: CURSOR get_partially_retrieved_pa
980: IS SELECT ROWIDTOCHAR(tc.ROWID)

Line 983: WHERE tc.ret_user_id = FND_GLOBAL.user_id

979: CURSOR get_partially_retrieved_pa
980: IS SELECT ROWIDTOCHAR(tc.ROWID)
981: FROM hxc_rdb_post_timecards tc,
982: hxc_pa_latest_details pay
983: WHERE tc.ret_user_id = FND_GLOBAL.user_id
984: AND tc.timecard_id = pay.timecard_id;
985:
986:
987: rowtab VARCHARTAB;

Line 1040: FND_GLOBAL.user_id

1036: ret_user_id)
1037: SELECT DISTINCT batch_id,
1038: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id) Timecards,
1039: 'N',
1040: FND_GLOBAL.user_id
1041: FROM hxc_rdb_post_timecards
1042: WHERE ret_user_id = FND_GLOBAL.user_id
1043: AND batch_id IS NOT NULL
1044: UNION

Line 1042: WHERE ret_user_id = FND_GLOBAL.user_id

1038: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id) Timecards,
1039: 'N',
1040: FND_GLOBAL.user_id
1041: FROM hxc_rdb_post_timecards
1042: WHERE ret_user_id = FND_GLOBAL.user_id
1043: AND batch_id IS NOT NULL
1044: UNION
1045: SELECT DISTINCT retro_batch_id,
1046: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id) Timecards,

Line 1048: FND_GLOBAL.user_id

1044: UNION
1045: SELECT DISTINCT retro_batch_id,
1046: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id) Timecards,
1047: 'Y',
1048: FND_GLOBAL.user_id
1049: FROM hxc_rdb_post_timecards
1050: WHERE ret_user_id = FND_GLOBAL.user_id
1051: AND retro_batch_id IS NOT NULL
1052: AND NVL(retro_batch_id,'0') <> NVL(batch_id,'0')

Line 1050: WHERE ret_user_id = FND_GLOBAL.user_id

1046: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id) Timecards,
1047: 'Y',
1048: FND_GLOBAL.user_id
1049: FROM hxc_rdb_post_timecards
1050: WHERE ret_user_id = FND_GLOBAL.user_id
1051: AND retro_batch_id IS NOT NULL
1052: AND NVL(retro_batch_id,'0') <> NVL(batch_id,'0')
1053: AND NVL(retro_batch_id,'0') <> NVL(old_batch_id,'0') ;
1054: COMMIT;

Line 1081: FND_GLOBAL.user_id

1077: attribute1,
1078: attribute2,
1079: attribute3),
1080: 1,
1081: FND_GLOBAL.user_id
1082: FROM hxc_rdb_post_details
1083: WHERE rec_line_id IS NOT NULL
1084: AND ret_user_id = FND_GLOBAL.user_id
1085: UNION

Line 1084: AND ret_user_id = FND_GLOBAL.user_id

1080: 1,
1081: FND_GLOBAL.user_id
1082: FROM hxc_rdb_post_details
1083: WHERE rec_line_id IS NOT NULL
1084: AND ret_user_id = FND_GLOBAL.user_id
1085: UNION
1086: SELECT DISTINCT '0' batch_id,
1087: attribute1,
1088: attribute2,

Line 1094: FND_GLOBAL.user_id

1090: SUM(measure) OVER (PARTITION BY attribute1,
1091: attribute2,
1092: attribute3),
1093: 1,
1094: FND_GLOBAL.user_id
1095: FROM hxc_rdb_post_details
1096: WHERE rec_line_id IS NOT NULL
1097: AND ret_user_id = FND_GLOBAL.user_id;
1098:

Line 1097: AND ret_user_id = FND_GLOBAL.user_id;

1093: 1,
1094: FND_GLOBAL.user_id
1095: FROM hxc_rdb_post_details
1096: WHERE rec_line_id IS NOT NULL
1097: AND ret_user_id = FND_GLOBAL.user_id;
1098:
1099:
1100: INSERT
1101: INTO hxc_rdb_post_attributes

Line 1118: FND_GLOBAL.user_id

1114: old_attribute1,
1115: old_attribute2,
1116: old_attribute3),
1117: -1,
1118: FND_GLOBAL.user_id
1119: FROM hxc_rdb_post_details
1120: WHERE rec_retro_line_id IS NOT NULL
1121: AND ret_user_id = FND_GLOBAL.user_id
1122: UNION

Line 1121: AND ret_user_id = FND_GLOBAL.user_id

1117: -1,
1118: FND_GLOBAL.user_id
1119: FROM hxc_rdb_post_details
1120: WHERE rec_retro_line_id IS NOT NULL
1121: AND ret_user_id = FND_GLOBAL.user_id
1122: UNION
1123: SELECT DISTINCT '0' retro_batch_id,
1124: old_attribute1,
1125: old_attribute2,

Line 1131: FND_GLOBAL.user_id

1127: SUM(-1*old_measure) OVER (PARTITION BY old_attribute1,
1128: old_attribute2,
1129: old_attribute3),
1130: -1,
1131: FND_GLOBAL.user_id
1132: FROM hxc_rdb_post_details
1133: WHERE rec_retro_line_id IS NOT NULL
1134: AND ret_user_id = FND_GLOBAL.user_id;
1135:

Line 1134: AND ret_user_id = FND_GLOBAL.user_id;

1130: -1,
1131: FND_GLOBAL.user_id
1132: FROM hxc_rdb_post_details
1133: WHERE rec_retro_line_id IS NOT NULL
1134: AND ret_user_id = FND_GLOBAL.user_id;
1135:
1136:
1137: INSERT INTO HXC_RDB_POST_ATTRIBUTES
1138: ( attribute1,

Line 1154: FND_GLOBAL.user_id

1150: SUM(measure),
1151: batch_id,
1152: ' (Total) 'total,
1153: 1,
1154: FND_GLOBAL.user_id
1155: FROM hxc_rdb_post_attributes
1156: WHERE ret_user_id = FND_GLOBAL.user_id
1157: GROUP BY batch_id,
1158: attribute1,

Line 1156: WHERE ret_user_id = FND_GLOBAL.user_id

1152: ' (Total) 'total,
1153: 1,
1154: FND_GLOBAL.user_id
1155: FROM hxc_rdb_post_attributes
1156: WHERE ret_user_id = FND_GLOBAL.user_id
1157: GROUP BY batch_id,
1158: attribute1,
1159: attribute2,
1160: attribute3 ;

Line 1183: FND_GLOBAL.user_id

1179: SELECT DISTINCT batch_id,
1180: supervisor_id,
1181: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1182: supervisor_id) ,
1183: FND_GLOBAL.user_id
1184: FROM hxc_rdb_post_timecards
1185: WHERE ret_user_id = FND_GLOBAL.user_id
1186: AND supervisor_id IS NOT NULL
1187: AND batch_id IS NOT NULL

Line 1185: WHERE ret_user_id = FND_GLOBAL.user_id

1181: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1182: supervisor_id) ,
1183: FND_GLOBAL.user_id
1184: FROM hxc_rdb_post_timecards
1185: WHERE ret_user_id = FND_GLOBAL.user_id
1186: AND supervisor_id IS NOT NULL
1187: AND batch_id IS NOT NULL
1188: UNION
1189: SELECT DISTINCT retro_batch_id,

Line 1193: FND_GLOBAL.user_id

1189: SELECT DISTINCT retro_batch_id,
1190: supervisor_id,
1191: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1192: supervisor_id) ,
1193: FND_GLOBAL.user_id
1194: FROM hxc_rdb_post_timecards
1195: WHERE ret_user_id = FND_GLOBAL.user_id
1196: AND supervisor_id IS NOT NULL
1197: AND retro_batch_id IS NOT NULL

Line 1195: WHERE ret_user_id = FND_GLOBAL.user_id

1191: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1192: supervisor_id) ,
1193: FND_GLOBAL.user_id
1194: FROM hxc_rdb_post_timecards
1195: WHERE ret_user_id = FND_GLOBAL.user_id
1196: AND supervisor_id IS NOT NULL
1197: AND retro_batch_id IS NOT NULL
1198: UNION
1199: SELECT '0' batch_id,

Line 1202: FND_GLOBAL.user_id

1198: UNION
1199: SELECT '0' batch_id,
1200: supervisor_id,
1201: COUNT(DISTINCT timecard_id) OVER (PARTITION BY supervisor_id) ,
1202: FND_GLOBAL.user_id
1203: FROM hxc_rdb_post_timecards
1204: WHERE ret_user_id = FND_GLOBAL.user_id
1205: AND supervisor_id IS NOT NULL;
1206: COMMIT;

Line 1204: WHERE ret_user_id = FND_GLOBAL.user_id

1200: supervisor_id,
1201: COUNT(DISTINCT timecard_id) OVER (PARTITION BY supervisor_id) ,
1202: FND_GLOBAL.user_id
1203: FROM hxc_rdb_post_timecards
1204: WHERE ret_user_id = FND_GLOBAL.user_id
1205: AND supervisor_id IS NOT NULL;
1206: COMMIT;
1207: END IF;
1208:

Line 1221: fnd_global.user_id

1217: SELECT DISTINCT batch_id,
1218: hrs_pm,
1219: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1220: hrs_pm) ,
1221: fnd_global.user_id
1222: FROM hxc_rdb_post_details
1223: WHERE ret_user_id = FND_GLOBAL.user_id
1224: AND batch_id IS NOT NULL
1225: UNION

Line 1223: WHERE ret_user_id = FND_GLOBAL.user_id

1219: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1220: hrs_pm) ,
1221: fnd_global.user_id
1222: FROM hxc_rdb_post_details
1223: WHERE ret_user_id = FND_GLOBAL.user_id
1224: AND batch_id IS NOT NULL
1225: UNION
1226: SELECT DISTINCT retro_batch_id,
1227: hrs_pm,

Line 1230: fnd_global.user_id

1226: SELECT DISTINCT retro_batch_id,
1227: hrs_pm,
1228: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1229: hrs_pm) ,
1230: fnd_global.user_id
1231: FROM hxc_rdb_post_details
1232: WHERE ret_user_id = FND_GLOBAL.user_id
1233: AND retro_batch_id IS NOT NULL
1234: UNION

Line 1232: WHERE ret_user_id = FND_GLOBAL.user_id

1228: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1229: hrs_pm) ,
1230: fnd_global.user_id
1231: FROM hxc_rdb_post_details
1232: WHERE ret_user_id = FND_GLOBAL.user_id
1233: AND retro_batch_id IS NOT NULL
1234: UNION
1235: SELECT DISTINCT '0' batch_id,
1236: hrs_pm,

Line 1238: fnd_global.user_id

1234: UNION
1235: SELECT DISTINCT '0' batch_id,
1236: hrs_pm,
1237: COUNT(DISTINCT timecard_id) OVER (PARTITION BY hrs_pm) measure,
1238: fnd_global.user_id
1239: FROM hxc_rdb_post_details
1240: WHERE ret_user_id = FND_GLOBAL.user_id;
1241:
1242: COMMIT;

Line 1240: WHERE ret_user_id = FND_GLOBAL.user_id;

1236: hrs_pm,
1237: COUNT(DISTINCT timecard_id) OVER (PARTITION BY hrs_pm) measure,
1238: fnd_global.user_id
1239: FROM hxc_rdb_post_details
1240: WHERE ret_user_id = FND_GLOBAL.user_id;
1241:
1242: COMMIT;
1243: END IF;
1244:

Line 1264: FND_GLOBAL.user_id

1260: SELECT DISTINCT batch_id,
1261: payroll_id,
1262: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1263: payroll_id) ,
1264: FND_GLOBAL.user_id
1265: FROM hxc_rdb_post_timecards
1266: WHERE ret_user_id = FND_GLOBAL.user_id
1267: AND payroll_id IS NOT NULL
1268: AND batch_id IS NOT NULL

Line 1266: WHERE ret_user_id = FND_GLOBAL.user_id

1262: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1263: payroll_id) ,
1264: FND_GLOBAL.user_id
1265: FROM hxc_rdb_post_timecards
1266: WHERE ret_user_id = FND_GLOBAL.user_id
1267: AND payroll_id IS NOT NULL
1268: AND batch_id IS NOT NULL
1269: UNION
1270: SELECT DISTINCT retro_batch_id,

Line 1274: FND_GLOBAL.user_id

1270: SELECT DISTINCT retro_batch_id,
1271: payroll_id,
1272: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1273: payroll_id) ,
1274: FND_GLOBAL.user_id
1275: FROM hxc_rdb_post_timecards
1276: WHERE ret_user_id = FND_GLOBAL.user_id
1277: AND payroll_id IS NOT NULL
1278: AND retro_batch_id IS NOT NULL

Line 1276: WHERE ret_user_id = FND_GLOBAL.user_id

1272: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1273: payroll_id) ,
1274: FND_GLOBAL.user_id
1275: FROM hxc_rdb_post_timecards
1276: WHERE ret_user_id = FND_GLOBAL.user_id
1277: AND payroll_id IS NOT NULL
1278: AND retro_batch_id IS NOT NULL
1279: UNION
1280: SELECT '0' batch_id,

Line 1283: FND_GLOBAL.user_id

1279: UNION
1280: SELECT '0' batch_id,
1281: payroll_id,
1282: COUNT(DISTINCT timecard_id) OVER (PARTITION BY payroll_id) ,
1283: FND_GLOBAL.user_id
1284: FROM hxc_rdb_post_timecards
1285: WHERE ret_user_id = FND_GLOBAL.user_id
1286: AND payroll_id IS NOT NULL;
1287: COMMIT;

Line 1285: WHERE ret_user_id = FND_GLOBAL.user_id

1281: payroll_id,
1282: COUNT(DISTINCT timecard_id) OVER (PARTITION BY payroll_id) ,
1283: FND_GLOBAL.user_id
1284: FROM hxc_rdb_post_timecards
1285: WHERE ret_user_id = FND_GLOBAL.user_id
1286: AND payroll_id IS NOT NULL;
1287: COMMIT;
1288: END IF;
1289:

Line 1305: FND_GLOBAL.user_id

1301: SELECT DISTINCT batch_id,
1302: attribute3,
1303: SUM(measure) OVER (PARTITION BY batch_id,
1304: attribute3) ,
1305: FND_GLOBAL.user_id
1306: FROM hxc_rdb_post_attributes
1307: WHERE ret_user_id = FND_GLOBAL.user_id
1308: AND total IS NULL ;
1309: COMMIT;

Line 1307: WHERE ret_user_id = FND_GLOBAL.user_id

1303: SUM(measure) OVER (PARTITION BY batch_id,
1304: attribute3) ,
1305: FND_GLOBAL.user_id
1306: FROM hxc_rdb_post_attributes
1307: WHERE ret_user_id = FND_GLOBAL.user_id
1308: AND total IS NULL ;
1309: COMMIT;
1310: END IF;
1311:

Line 1335: FND_GLOBAL.user_id

1331: stop_time,
1332: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1333: start_time,
1334: stop_time),
1335: FND_GLOBAL.user_id
1336: FROM hxc_rdb_post_timecards
1337: WHERE partially_retrieved = 'Y'
1338: AND batch_id IS NOT NULL
1339: AND ret_user_id = FND_GLOBAL.user_id

Line 1339: AND ret_user_id = FND_GLOBAL.user_id

1335: FND_GLOBAL.user_id
1336: FROM hxc_rdb_post_timecards
1337: WHERE partially_retrieved = 'Y'
1338: AND batch_id IS NOT NULL
1339: AND ret_user_id = FND_GLOBAL.user_id
1340: UNION
1341: SELECT DISTINCT retro_batch_id,
1342: start_time,
1343: stop_time,

Line 1347: FND_GLOBAL.user_id

1343: stop_time,
1344: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1345: start_time,
1346: stop_time),
1347: FND_GLOBAL.user_id
1348: FROM hxc_rdb_post_timecards
1349: WHERE partially_retrieved = 'Y'
1350: AND retro_batch_id IS NOT NULL
1351: AND ret_user_id = FND_GLOBAL.user_id

Line 1351: AND ret_user_id = FND_GLOBAL.user_id

1347: FND_GLOBAL.user_id
1348: FROM hxc_rdb_post_timecards
1349: WHERE partially_retrieved = 'Y'
1350: AND retro_batch_id IS NOT NULL
1351: AND ret_user_id = FND_GLOBAL.user_id
1352: UNION
1353: SELECT DISTINCT '0' batch_id,
1354: start_time,
1355: stop_time,

Line 1358: FND_GLOBAL.user_id

1354: start_time,
1355: stop_time,
1356: COUNT(DISTINCT timecard_id) OVER (PARTITION BY start_time,
1357: stop_time),
1358: FND_GLOBAL.user_id
1359: FROM hxc_rdb_post_timecards
1360: WHERE partially_retrieved = 'Y'
1361: AND ret_user_id = FND_GLOBAL.user_id ;
1362: COMMIT;

Line 1361: AND ret_user_id = FND_GLOBAL.user_id ;

1357: stop_time),
1358: FND_GLOBAL.user_id
1359: FROM hxc_rdb_post_timecards
1360: WHERE partially_retrieved = 'Y'
1361: AND ret_user_id = FND_GLOBAL.user_id ;
1362: COMMIT;
1363:
1364: END summarize_partial;
1365:

Line 1386: FND_GLOBAL.user_id

1382: stop_time,
1383: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1384: start_time,
1385: stop_time),
1386: FND_GLOBAL.user_id
1387: FROM hxc_rdb_post_timecards
1388: WHERE batch_id IS NOT NULL
1389: AND ret_user_id = FND_GLOBAL.user_id
1390: UNION

Line 1389: AND ret_user_id = FND_GLOBAL.user_id

1385: stop_time),
1386: FND_GLOBAL.user_id
1387: FROM hxc_rdb_post_timecards
1388: WHERE batch_id IS NOT NULL
1389: AND ret_user_id = FND_GLOBAL.user_id
1390: UNION
1391: SELECT DISTINCT retro_batch_id,
1392: start_time,
1393: stop_time,

Line 1397: FND_GLOBAL.user_id

1393: stop_time,
1394: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1395: start_time,
1396: stop_time),
1397: FND_GLOBAL.user_id
1398: FROM hxc_rdb_post_timecards
1399: WHERE retro_batch_id IS NOT NULL
1400: AND ret_user_id = FND_GLOBAL.user_id
1401: UNION

Line 1400: AND ret_user_id = FND_GLOBAL.user_id

1396: stop_time),
1397: FND_GLOBAL.user_id
1398: FROM hxc_rdb_post_timecards
1399: WHERE retro_batch_id IS NOT NULL
1400: AND ret_user_id = FND_GLOBAL.user_id
1401: UNION
1402: SELECT DISTINCT '0' batch_id,
1403: start_time,
1404: stop_time,

Line 1407: FND_GLOBAL.user_id

1403: start_time,
1404: stop_time,
1405: COUNT(DISTINCT timecard_id) OVER (PARTITION BY start_time,
1406: stop_time),
1407: FND_GLOBAL.user_id
1408: FROM hxc_rdb_post_timecards
1409: WHERE ret_user_id = FND_GLOBAL.user_id ;
1410: COMMIT;
1411:

Line 1409: WHERE ret_user_id = FND_GLOBAL.user_id ;

1405: COUNT(DISTINCT timecard_id) OVER (PARTITION BY start_time,
1406: stop_time),
1407: FND_GLOBAL.user_id
1408: FROM hxc_rdb_post_timecards
1409: WHERE ret_user_id = FND_GLOBAL.user_id ;
1410: COMMIT;
1411:
1412: END summarize_distinct;
1413:

Line 1430: FND_GLOBAL.user_id

1426: SELECT DISTINCT batch_id,
1427: org_job_id,
1428: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1429: org_job_id) ,
1430: FND_GLOBAL.user_id
1431: FROM hxc_rdb_post_timecards
1432: WHERE ret_user_id = FND_GLOBAL.user_id
1433: AND org_job_id IS NOT NULL
1434: AND batch_id IS NOT NULL

Line 1432: WHERE ret_user_id = FND_GLOBAL.user_id

1428: COUNT(DISTINCT timecard_id) OVER (PARTITION BY batch_id,
1429: org_job_id) ,
1430: FND_GLOBAL.user_id
1431: FROM hxc_rdb_post_timecards
1432: WHERE ret_user_id = FND_GLOBAL.user_id
1433: AND org_job_id IS NOT NULL
1434: AND batch_id IS NOT NULL
1435: UNION
1436: SELECT DISTINCT retro_batch_id,

Line 1440: FND_GLOBAL.user_id

1436: SELECT DISTINCT retro_batch_id,
1437: org_job_id,
1438: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1439: org_job_id) ,
1440: FND_GLOBAL.user_id
1441: FROM hxc_rdb_post_timecards
1442: WHERE ret_user_id = FND_GLOBAL.user_id
1443: AND org_job_id IS NOT NULL
1444: AND retro_batch_id IS NOT NULL

Line 1442: WHERE ret_user_id = FND_GLOBAL.user_id

1438: COUNT(DISTINCT timecard_id) OVER (PARTITION BY retro_batch_id,
1439: org_job_id) ,
1440: FND_GLOBAL.user_id
1441: FROM hxc_rdb_post_timecards
1442: WHERE ret_user_id = FND_GLOBAL.user_id
1443: AND org_job_id IS NOT NULL
1444: AND retro_batch_id IS NOT NULL
1445: UNION
1446: SELECT '0' batch_id,

Line 1449: FND_GLOBAL.user_id

1445: UNION
1446: SELECT '0' batch_id,
1447: org_job_id,
1448: COUNT(DISTINCT timecard_id) OVER (PARTITION BY org_job_id) ,
1449: FND_GLOBAL.user_id
1450: FROM hxc_rdb_post_timecards
1451: WHERE ret_user_id = FND_GLOBAL.user_id
1452: AND org_job_id IS NOT NULL;
1453: COMMIT;

Line 1451: WHERE ret_user_id = FND_GLOBAL.user_id

1447: org_job_id,
1448: COUNT(DISTINCT timecard_id) OVER (PARTITION BY org_job_id) ,
1449: FND_GLOBAL.user_id
1450: FROM hxc_rdb_post_timecards
1451: WHERE ret_user_id = FND_GLOBAL.user_id
1452: AND org_job_id IS NOT NULL;
1453: COMMIT;
1454:
1455: END summarize_org;

Line 1472: AND rdb.ret_user_id = FND_GLOBAL.user_id

1468: PA_PROJECT_ROLE_TYPES_B PPRT,
1469: per_people_f ppf, -- Bug 12605349
1470: pa_projects_all proj
1471: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1472: AND rdb.ret_user_id = FND_GLOBAL.user_id
1473: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1474: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'
1475: AND PPRT.role_party_class = 'PERSON'
1476: AND SYSDATE BETWEEN ppf.effective_start_date

Line 1492: AND rdb.ret_user_id = FND_GLOBAL.user_id;

1488: per_people_f ppf -- Bug 12605349
1489: WHERE SYSDATE BETWEEN ppf.effective_start_date
1490: AND ppf.effective_end_date
1491: AND rdb.hrs_pm = ppf.person_id
1492: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1493:
1494:
1495: nametab VARCHARTAB;
1496: idtab NUMBERTAB;

Line 1564: AND rdb.ret_user_id = FND_GLOBAL.user_id;

1560: ROWIDTOCHAR(rdb.ROWID)
1561: FROM hxc_rdb_post_batches rdb,
1562: pay_batch_headers pbh
1563: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
1564: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1565:
1566:
1567: nametab VARCHARTAB;
1568: rowtab VARCHARTAB;

Line 1596: WHERE ret_user_id = FND_GLOBAL.user_id;

1592: IF p_application = 'PA'
1593: THEN
1594: UPDATE hxc_rdb_post_batches
1595: SET batch_name = batch_id
1596: WHERE ret_user_id = FND_GLOBAL.user_id;
1597: END IF;
1598:
1599:
1600: END translate_batches;

Line 1617: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

1613: FROM hxc_rdb_post_attributes rdb,
1614: pa_projects_all proj,
1615: pa_tasks_expend_v task /*Bug 16391367*/
1616:
1617: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1618: AND rdb.attribute1 = proj.project_id
1619: AND rdb.attribute2 = task.task_id;
1620:
1621: CURSOR get_elements

Line 1626: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

1622: IS SELECT pay.element_name,
1623: ROWIDTOCHAR(rdb.ROWID)
1624: FROM hxc_rdb_post_attributes rdb,
1625: pay_element_types_f_tl pay
1626: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1627: AND pay.language = USERENV('LANG')
1628: AND rdb.attribute1 = pay.element_type_id;
1629:
1630: atttab VARCHARTAB;

Line 1697: AND rdb.ret_user_id = FND_GLOBAL.user_id

1693: PA_PROJECT_PARTIES PPP ,
1694: PA_PROJECT_ROLE_TYPES_B PPRT,
1695: per_people_f ppf -- Bug 12605349
1696: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1697: AND rdb.ret_user_id = FND_GLOBAL.user_id
1698: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1699: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'
1700: AND PPRT.role_party_class = 'PERSON'
1701: AND SYSDATE BETWEEN ppf.effective_start_date

Line 1713: AND rdb.ret_user_id = FND_GLOBAL.user_id;

1709: ROWIDTOCHAR(rdb.ROWID)
1710: FROM hxc_rdb_post_payroll_exp_type rdb,
1711: pay_payrolls_f ppf
1712: WHERE rdb.payroll_exp_id = ppf.payroll_id
1713: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1714:
1715:
1716: nametab VARCHARTAB;
1717: rowtab VARCHARTAB;

Line 1745: WHERE ret_user_id = FND_GLOBAL.user_id;

1741: IF p_application = 'PA'
1742: THEN
1743: UPDATE hxc_rdb_post_payroll_exp_type
1744: SET payroll_exp_name = payroll_exp_id
1745: WHERE ret_user_id = FND_GLOBAL.user_id;
1746: END IF;
1747:
1748:
1749: END translate_payroll;

Line 1765: AND rdb.ret_user_id = FND_GLOBAL.user_id

1761: PA_PROJECT_PARTIES PPP ,
1762: PA_PROJECT_ROLE_TYPES_B PPRT,
1763: per_people_f ppf -- Bug 12605349
1764: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1765: AND rdb.ret_user_id = FND_GLOBAL.user_id
1766: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1767: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'
1768: AND PPRT.role_party_class = 'PERSON'
1769: AND SYSDATE BETWEEN ppf.effective_start_date

Line 1781: AND rdb.ret_user_id = FND_GLOBAL.user_id;

1777: ROWIDTOCHAR(rdb.ROWID)
1778: FROM hxc_rdb_post_org_job rdb,
1779: hr_organization_units org -- Bug 12605349
1780: WHERE rdb.org_job_id = org.organization_id
1781: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1782:
1783: CURSOR get_job_name
1784: IS SELECT job.name,
1785: ROWIDTOCHAR(rdb.ROWID)

Line 1789: AND rdb.ret_user_id = FND_GLOBAL.user_id;

1785: ROWIDTOCHAR(rdb.ROWID)
1786: FROM hxc_rdb_post_org_job rdb,
1787: per_jobs job
1788: WHERE rdb.org_job_id = job.job_id
1789: AND rdb.ret_user_id = FND_GLOBAL.user_id;
1790:
1791:
1792:
1793: nametab VARCHARTAB;

Line 1945: FND_GLOBAL.user_id);

1941: oldtab(i),
1942: rettab(i),
1943: starttab(i),
1944: stoptab(i),
1945: FND_GLOBAL.user_id);
1946:
1947: COMMIT;
1948:
1949: END LOOP;

Line 2032: FND_GLOBAL.user_id);

2028: oldtab(i),
2029: rettab(i),
2030: starttab(i),
2031: stoptab(i),
2032: FND_GLOBAL.user_id);
2033:
2034: COMMIT;
2035:
2036: END LOOP;

Line 2082: WHERE ret_user_id = FND_GLOBAL.user_id;

2078:
2079: CURSOR get_old_timecards
2080: IS SELECT ROWIDTOCHAR(ROWID)
2081: FROM hxc_rdb_post_timecards
2082: WHERE ret_user_id = FND_GLOBAL.user_id;
2083:
2084: CURSOR get_old_details
2085: IS SELECT ROWIDTOCHAR(ROWID)
2086: FROM hxc_rdb_post_details

Line 2087: WHERE ret_user_id = FND_GLOBAL.user_id;

2083:
2084: CURSOR get_old_details
2085: IS SELECT ROWIDTOCHAR(ROWID)
2086: FROM hxc_rdb_post_details
2087: WHERE ret_user_id = FND_GLOBAL.user_id;
2088:
2089: rowtab VARCHARTAB;
2090:
2091: BEGIN

Line 2122: WHERE ret_user_id = FND_GLOBAL.user_id;

2118: CLOSE get_old_details;
2119:
2120:
2121: DELETE FROM hxc_rdb_post_batches
2122: WHERE ret_user_id = FND_GLOBAL.user_id;
2123:
2124: DELETE FROM hxc_rdb_post_attributes
2125: WHERE ret_user_id = FND_GLOBAL.user_id;
2126:

Line 2125: WHERE ret_user_id = FND_GLOBAL.user_id;

2121: DELETE FROM hxc_rdb_post_batches
2122: WHERE ret_user_id = FND_GLOBAL.user_id;
2123:
2124: DELETE FROM hxc_rdb_post_attributes
2125: WHERE ret_user_id = FND_GLOBAL.user_id;
2126:
2127: DELETE FROM hxc_rdb_post_hrs_pm
2128: WHERE ret_user_id = FND_GLOBAL.user_id;
2129:

Line 2128: WHERE ret_user_id = FND_GLOBAL.user_id;

2124: DELETE FROM hxc_rdb_post_attributes
2125: WHERE ret_user_id = FND_GLOBAL.user_id;
2126:
2127: DELETE FROM hxc_rdb_post_hrs_pm
2128: WHERE ret_user_id = FND_GLOBAL.user_id;
2129:
2130: DELETE FROM hxc_rdb_post_payroll_exp_type
2131: WHERE ret_user_id = FND_GLOBAL.user_id;
2132:

Line 2131: WHERE ret_user_id = FND_GLOBAL.user_id;

2127: DELETE FROM hxc_rdb_post_hrs_pm
2128: WHERE ret_user_id = FND_GLOBAL.user_id;
2129:
2130: DELETE FROM hxc_rdb_post_payroll_exp_type
2131: WHERE ret_user_id = FND_GLOBAL.user_id;
2132:
2133: DELETE FROM hxc_rdb_post_partial_timecards
2134: WHERE ret_user_id = FND_GLOBAL.user_id;
2135:

Line 2134: WHERE ret_user_id = FND_GLOBAL.user_id;

2130: DELETE FROM hxc_rdb_post_payroll_exp_type
2131: WHERE ret_user_id = FND_GLOBAL.user_id;
2132:
2133: DELETE FROM hxc_rdb_post_partial_timecards
2134: WHERE ret_user_id = FND_GLOBAL.user_id;
2135:
2136: DELETE FROM hxc_rdb_post_dist_timecards
2137: WHERE ret_user_id = FND_GLOBAL.user_id;
2138:

Line 2137: WHERE ret_user_id = FND_GLOBAL.user_id;

2133: DELETE FROM hxc_rdb_post_partial_timecards
2134: WHERE ret_user_id = FND_GLOBAL.user_id;
2135:
2136: DELETE FROM hxc_rdb_post_dist_timecards
2137: WHERE ret_user_id = FND_GLOBAL.user_id;
2138:
2139: DELETE FROM hxc_rdb_post_org_job
2140: WHERE ret_user_id = FND_GLOBAL.user_id;
2141:

Line 2140: WHERE ret_user_id = FND_GLOBAL.user_id;

2136: DELETE FROM hxc_rdb_post_dist_timecards
2137: WHERE ret_user_id = FND_GLOBAL.user_id;
2138:
2139: DELETE FROM hxc_rdb_post_org_job
2140: WHERE ret_user_id = FND_GLOBAL.user_id;
2141:
2142: DELETE FROM hxc_rdb_post_tc_details
2143: WHERE ret_user_id = FND_GLOBAL.user_id;
2144:

Line 2143: WHERE ret_user_id = FND_GLOBAL.user_id;

2139: DELETE FROM hxc_rdb_post_org_job
2140: WHERE ret_user_id = FND_GLOBAL.user_id;
2141:
2142: DELETE FROM hxc_rdb_post_tc_details
2143: WHERE ret_user_id = FND_GLOBAL.user_id;
2144:
2145:
2146: COMMIT;
2147:

Line 2167: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

2163: FROM hxc_rdb_post_tc_details rdb,
2164: pa_projects_all proj,
2165: pa_tasks_expend_v task /*Bug 16391367*/
2166:
2167: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
2168: AND rdb.attribute1 = proj.project_id
2169: AND rdb.attribute2 = task.task_id;
2170:
2171: CURSOR get_elements

Line 2176: WHERE rdb.ret_user_id = FND_GLOBAL.user_id

2172: IS SELECT pay.element_name,
2173: ROWIDTOCHAR(rdb.ROWID)
2174: FROM hxc_rdb_post_tc_details rdb,
2175: pay_element_types_f_tl pay
2176: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
2177: AND pay.language = USERENV('LANG')
2178: AND rdb.attribute1 = pay.element_type_id;
2179:
2180:

Line 2190: AND rdb.ret_user_id = FND_GLOBAL.user_id;

2186: ROWIDTOCHAR(rdb.ROWID)
2187: FROM hxc_rdb_post_tc_details rdb,
2188: pay_batch_headers pbh
2189: WHERE REPLACE(rdb.batch_id,'(Retro)') = pbh.batch_id
2190: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2191:
2192: CURSOR get_batch_name_old
2193: IS SELECT pbh.batch_name,
2194: ROWIDTOCHAR(rdb.ROWID)

Line 2198: AND rdb.ret_user_id = FND_GLOBAL.user_id;

2194: ROWIDTOCHAR(rdb.ROWID)
2195: FROM hxc_rdb_post_tc_details rdb,
2196: pay_batch_headers pbh
2197: WHERE rdb.old_batch_id = pbh.batch_id
2198: AND rdb.ret_user_id = FND_GLOBAL.user_id;
2199:
2200:
2201: atttab VARCHARTAB;
2202: rowtab VARCHARTAB;

Line 2208: WHERE ret_user_id = FND_GLOBAL.user_id;

2204:
2205: BEGIN
2206:
2207: DELETE FROM hxc_rdb_post_tc_details
2208: WHERE ret_user_id = FND_GLOBAL.user_id;
2209: COMMIT;
2210:
2211: INSERT INTO hxc_rdb_post_tc_details
2212: (time_building_block_id,

Line 2239: FND_GLOBAL.user_id

2235: NULL,
2236: NULL,
2237: NULL,
2238: timecard_id,
2239: FND_GLOBAL.user_id
2240: FROM hxc_rdb_post_details det
2241: WHERE timecard_id = p_timecard_id
2242: AND rec_line_id IS NOT NULL
2243: AND ret_user_id = FND_GLOBAL.user_id

Line 2243: AND ret_user_id = FND_GLOBAL.user_id

2239: FND_GLOBAL.user_id
2240: FROM hxc_rdb_post_details det
2241: WHERE timecard_id = p_timecard_id
2242: AND rec_line_id IS NOT NULL
2243: AND ret_user_id = FND_GLOBAL.user_id
2244: UNION
2245: ALL
2246: SELECT DISTINCT time_building_block_id,
2247: date_worked,

Line 2259: FND_GLOBAL.user_id

2255: adj_rec_line_id,
2256: old_batch_id,
2257: old_request_id,
2258: timecard_id,
2259: FND_GLOBAL.user_id
2260: FROM hxc_rdb_post_details det
2261: WHERE timecard_id = p_timecard_id
2262: AND rec_retro_line_id IS NOT NULL
2263: AND ret_user_id = FND_GLOBAL.user_id ;

Line 2263: AND ret_user_id = FND_GLOBAL.user_id ;

2259: FND_GLOBAL.user_id
2260: FROM hxc_rdb_post_details det
2261: WHERE timecard_id = p_timecard_id
2262: AND rec_retro_line_id IS NOT NULL
2263: AND ret_user_id = FND_GLOBAL.user_id ;
2264:
2265: COMMIT;
2266:
2267: IF p_application = 'PA'

Line 2290: AND ret_user_id = FND_GLOBAL.user_id;

2286: UPDATE hxc_rdb_post_tc_details
2287: SET batch_name = batch_id,
2288: old_line_details = RTRIM(adj_rec_line_id||' - '||old_batch_id||' - '||old_request_id,' - ')
2289: WHERE timecard_id = p_timecard_id
2290: AND ret_user_id = FND_GLOBAL.user_id;
2291:
2292: END IF;
2293:
2294: IF p_application = 'PAY'

Line 2417: || 'where user_id = fnd_global.user_id' ;

2413: query1 := 'SELECT '
2414: || 'user_name INITIATED_BY, '
2415: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
2416: || 'from fnd_user '
2417: || 'where user_id = fnd_global.user_id' ;
2418:
2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');