APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_HRS_PM

Line 385: INTO hxc_rdb_pre_hrs_pm

381: BEGIN
382: IF p_application = 'PA'
383: THEN
384: INSERT
385: INTO hxc_rdb_pre_hrs_pm
386: (approval_status,
387: hrs_pm,
388: timecards,
389: ret_user_id)

Line 411: INSERT into hxc_rdb_pre_hrs_pm

407: END IF;
408:
409: IF p_application = 'PAY'
410: THEN
411: INSERT into hxc_rdb_pre_hrs_pm
412: (approval_status,
413: hrs_pm,
414: timecards,
415: ret_user_id)

Line 476: FROM hxc_rdb_pre_hrs_pm rdb,

472: CURSOR get_proj_manager
473: IS SELECT ppf.full_name||'('||proj.name||')',
474: ppf.person_id,
475: ROWIDTOCHAR(rdb.rowid)
476: FROM hxc_rdb_pre_hrs_pm rdb,
477: PA_PROJECT_PARTIES PPP ,
478: PA_PROJECT_ROLE_TYPES_B PPRT,
479: per_people_f ppf, -- Bug 12605349
480: pa_projects_all proj

Line 497: FROM hxc_rdb_pre_hrs_pm rdb,

493: CURSOR get_hrs_name
494: IS SELECT ppf.full_name,
495: ppf.person_id,
496: ROWIDTOCHAR(rdb.rowid)
497: FROM hxc_rdb_pre_hrs_pm rdb,
498: per_people_f ppf -- Bug 12605349
499: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118
500: AND ppf.effective_end_date
501: AND rdb.hrs_pm = ppf.person_id

Line 520: UPDATE hxc_rdb_pre_hrs_pm

516: rowtab LIMIT 500;
517: EXIT WHEN nametab.COUNT = 0;
518:
519: FORALL i IN nametab.FIRST..nametab.LAST
520: UPDATE hxc_rdb_pre_hrs_pm
521: SET hrs_pm_name = nametab(i),
522: resource_id = idtab(i)
523: WHERE rowid = chartorowid(rowtab(i));
524:

Line 541: UPDATE hxc_rdb_pre_hrs_pm

537: rowtab LIMIT 500;
538: EXIT WHEN nametab.COUNT = 0;
539:
540: FORALL i IN nametab.FIRST..nametab.LAST
541: UPDATE hxc_rdb_pre_hrs_pm
542: SET hrs_pm_name = nametab(i),
543: resource_id = idtab(i)
544: WHERE ROWID = CHARTOROWID(rowtab(i));
545:

Line 1100: DELETE FROM hxc_rdb_pre_hrs_pm

1096:
1097: DELETE FROM hxc_rdb_pre_attributes
1098: WHERE ret_user_id = FND_GLOBAL.user_id;
1099:
1100: DELETE FROM hxc_rdb_pre_hrs_pm
1101: WHERE ret_user_id = FND_GLOBAL.user_id;
1102:
1103: DELETE FROM hxc_rdb_pre_updated
1104: WHERE ret_user_id = FND_GLOBAL.user_id;