APPS.HXC_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_HRS_PM

Line 1174: INSERT INTO hxc_rdb_post_hrs_pm

1170: BEGIN
1171:
1172: IF p_application = 'PAY'
1173: THEN
1174: INSERT INTO hxc_rdb_post_hrs_pm
1175: (batch_id,
1176: hrs_pm,
1177: timecards,
1178: ret_user_id)

Line 1212: INTO hxc_rdb_post_hrs_pm

1208:
1209: IF p_application = 'PA'
1210: THEN
1211: INSERT
1212: INTO hxc_rdb_post_hrs_pm
1213: (batch_id,
1214: hrs_pm,
1215: timecards,
1216: ret_user_id)

Line 1466: FROM hxc_rdb_post_hrs_pm rdb,

1462: CURSOR get_proj_manager
1463: IS SELECT ppf.full_name||'('||proj.name||')',
1464: ppf.person_id,
1465: ROWIDTOCHAR(rdb.ROWID)
1466: FROM hxc_rdb_post_hrs_pm rdb,
1467: PA_PROJECT_PARTIES PPP ,
1468: PA_PROJECT_ROLE_TYPES_B PPRT,
1469: per_people_f ppf, -- Bug 12605349
1470: pa_projects_all proj

Line 1487: FROM hxc_rdb_post_hrs_pm rdb,

1483: CURSOR get_hrs_name
1484: IS SELECT ppf.full_name,
1485: ppf.person_id,
1486: ROWIDTOCHAR(rdb.ROWID)
1487: FROM hxc_rdb_post_hrs_pm rdb,
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

Line 1511: UPDATE hxc_rdb_post_hrs_pm

1507: rowtab LIMIT 500;
1508: EXIT WHEN nametab.COUNT = 0;
1509:
1510: FORALL i IN nametab.FIRST..nametab.LAST
1511: UPDATE hxc_rdb_post_hrs_pm
1512: SET hrs_pm_name = nametab(i),
1513: resource_id = idtab(i)
1514: WHERE ROWID = CHARTOROWID(rowtab(i));
1515:

Line 1533: UPDATE hxc_rdb_post_hrs_pm

1529: rowtab LIMIT 500;
1530: EXIT WHEN nametab.COUNT = 0;
1531:
1532: FORALL i IN nametab.FIRST..nametab.LAST
1533: UPDATE hxc_rdb_post_hrs_pm
1534: SET hrs_pm_name = nametab(i),
1535: resource_id = idtab(i)
1536: WHERE ROWID = CHARTOROWID(rowtab(i));
1537:

Line 2127: DELETE FROM hxc_rdb_post_hrs_pm

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:
2130: DELETE FROM hxc_rdb_post_payroll_exp_type
2131: WHERE ret_user_id = FND_GLOBAL.user_id;