APPS.HXC_RDB_RECIPIENT_SNAPSHOT dependencies on HXC_RET_PA_LATEST_DETAILS

Line 13: FROM hxc_ret_pa_latest_details ret,

9: CURSOR get_retro_exp
10: IS SELECT pa.expenditure_item_id,
11: exp.expenditure_group,
12: ROWIDTOCHAR(ret.rowid)
13: FROM hxc_ret_pa_latest_details ret,
14: pa_expenditure_items_all pa,
15: pa_expenditures_all exp
16: WHERE ret.request_id = p_request_id
17: AND pa.transaction_source = 'ORACLE TIME AND LABOR'

Line 27: FROM hxc_ret_pa_latest_details ret,

23: CURSOR get_new_exp
24: IS SELECT pa.expenditure_item_id,
25: exp.expenditure_group,
26: ROWIDTOCHAR(ret.rowid)
27: FROM hxc_ret_pa_latest_details ret,
28: pa_expenditure_items_all pa,
29: pa_expenditures_all exp
30: WHERE ret.request_id = p_request_id
31: AND pa.transaction_source = 'ORACLE TIME AND LABOR'

Line 89: UPDATE hxc_ret_pa_latest_details

85:
86: EXIT WHEN eitab.COUNT = 0;
87:
88: FORALL i IN eitab.FIRST..eitab.LAST
89: UPDATE hxc_ret_pa_latest_details
90: SET retro_pei_id = eitab(i),
91: retro_exp_group = ettab(i)
92: WHERE ROWID = CHARTOROWID(rowtab(i));
93: COMMIT;

Line 107: UPDATE hxc_ret_pa_latest_details

103:
104: EXIT WHEN eitab.COUNT = 0;
105:
106: FORALL i IN eitab.FIRST..eitab.LAST
107: UPDATE hxc_ret_pa_latest_details
108: SET pei_id = eitab(i),
109: exp_group = ettab(i)
110: WHERE ROWID = CHARTOROWID(rowtab(i));
111: COMMIT;