APPS.HXC_RDB_POST_RETRIEVAL dependencies on HXC_RDB_POST_PAYROLL_EXP_TYPE

Line 1255: INSERT INTO hxc_rdb_post_payroll_exp_type

1251: BEGIN
1252:
1253: IF p_application = 'PAY'
1254: THEN
1255: INSERT INTO hxc_rdb_post_payroll_exp_type
1256: (batch_id,
1257: payroll_exp_id,
1258: timecards,
1259: ret_user_id)

Line 1296: INSERT INTO hxc_rdb_post_payroll_exp_type

1292: -- Added the condition to avoid the totals
1293: -- adding up here.
1294: IF p_application = 'PA'
1295: THEN
1296: INSERT INTO hxc_rdb_post_payroll_exp_type
1297: (batch_id,
1298: payroll_exp_id,
1299: timecards,
1300: ret_user_id)

Line 1710: FROM hxc_rdb_post_payroll_exp_type rdb,

1706:
1707: CURSOR get_payroll_name
1708: IS SELECT ppf.payroll_name,
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:

Line 1730: UPDATE hxc_rdb_post_payroll_exp_type

1726: rowtab LIMIT 500;
1727: EXIT WHEN nametab.COUNT = 0;
1728:
1729: FORALL i IN nametab.FIRST..nametab.LAST
1730: UPDATE hxc_rdb_post_payroll_exp_type
1731: SET payroll_exp_name = nametab(i)
1732: WHERE ROWID = CHARTOROWID(rowtab(i));
1733:
1734: COMMIT;

Line 1743: UPDATE hxc_rdb_post_payroll_exp_type

1739: END IF;
1740:
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:

Line 2130: DELETE FROM hxc_rdb_post_payroll_exp_type

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:
2133: DELETE FROM hxc_rdb_post_partial_timecards
2134: WHERE ret_user_id = FND_GLOBAL.user_id;