DBA Data[Home] [Help]

APPS.HXT_BATCH_PROCESS dependencies on HXT_BATCH_VALUES_V

Line 1462: PROCEDURE dtl_to_BEE(p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE,

1458: -- What need to be noted that it is the customer's responsibilty to create
1459: -- input values which are the direct translation of 'Hours','Hourly Rate',
1460: -- 'Pay Value' , 'Rate Multiple' and 'Rate Code'
1461: --
1462: PROCEDURE dtl_to_BEE(p_values_rec IN HXT_BATCH_VALUES_V%ROWTYPE,
1463: p_sum_retcode IN OUT NOCOPY NUMBER,
1464: p_batch_sequence IN NUMBER)
1465: IS
1466: --l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

Line 1597: FROM hxt_batch_values_v

1593: p_county_name VARCHAR2,
1594: p_city_name VARCHAR2,
1595: p_zip_code VARCHAR2)
1596: IS SELECT hrw_rowid
1597: FROM hxt_batch_values_v
1598: WHERE element_type_id = p_element_type_id
1599: AND assignment_id = p_assignment_id
1600: AND batch_id = p_batch_id
1601: AND assignment_number = p_assignment_number

Line 2433: FROM hxt_batch_values_v

2429: p_sum_retcode IN OUT NOCOPY NUMBER) IS
2430: PRAGMA AUTONOMOUS_TRANSACTION; --115.37
2431: CURSOR hxt_values_cur IS
2432: SELECT *
2433: FROM hxt_batch_values_v
2434: WHERE batch_id = p_batch_id ;
2435: CURSOR hxt_hours_cur IS
2436: SELECT *
2437: FROM hxt_batch_sum_hours_rollup_v