APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_BATCH_HEADERS

Line 1823: FROM hxt_timecards_f HTF, pay_batch_headers pbh

1819:
1820: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1821: IS
1822: SELECT HTF.ID
1823: FROM hxt_timecards_f HTF, pay_batch_headers pbh
1824: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1825: AND HTF.batch_id = pbh.batch_id
1826: ORDER BY for_person_id, time_period_id;
1827:

Line 2594: FROM pay_batch_headers pbh

2590: THEN
2591: BEGIN
2592: SELECT MAX (pbh.batch_name)
2593: INTO l_batch_name
2594: FROM pay_batch_headers pbh
2595: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
2596: AND pbh.batch_reference NOT LIKE '%RETRO%'
2597: AND pbh.batch_status NOT IN ('T', 'TW');
2598: EXCEPTION

Line 2607: FROM pay_batch_headers pbh

2603: ELSE
2604: BEGIN
2605: SELECT MAX (pbh.batch_name)
2606: INTO l_batch_name
2607: FROM pay_batch_headers pbh
2608: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
2609: AND pbh.batch_status NOT IN ('T', 'TW');
2610: EXCEPTION
2611: WHEN NO_DATA_FOUND

Line 2631: FROM pay_batch_lines pbl, pay_batch_headers pbh

2627: IF l_batch_name IS NOT NULL
2628: THEN
2629: SELECT COUNT (pbl.batch_line_id)
2630: INTO l_batch_lines
2631: FROM pay_batch_lines pbl, pay_batch_headers pbh
2632: WHERE pbh.batch_name = l_batch_name
2633: AND pbl.batch_id = pbh.batch_id;
2634:
2635: --