APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PAY_BATCH_HEADERS

Line 1235: FROM hxt_timecards_f HTF, pay_batch_headers pbh

1231:
1232: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1233: IS
1234: SELECT HTF.ID
1235: FROM hxt_timecards_f HTF, pay_batch_headers pbh
1236: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1237: AND HTF.batch_id = pbh.batch_id
1238: ORDER BY for_person_id, time_period_id;
1239:

Line 1940: FROM pay_batch_headers pbh

1936: THEN
1937: BEGIN
1938: SELECT MAX (pbh.batch_name)
1939: INTO l_batch_name
1940: FROM pay_batch_headers pbh
1941: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1942: AND pbh.batch_reference NOT LIKE '%RETRO%'
1943: AND pbh.batch_status NOT IN ('T', 'TW');
1944: EXCEPTION

Line 1953: FROM pay_batch_headers pbh

1949: ELSE
1950: BEGIN
1951: SELECT MAX (pbh.batch_name)
1952: INTO l_batch_name
1953: FROM pay_batch_headers pbh
1954: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1955: AND pbh.batch_status NOT IN ('T', 'TW');
1956: EXCEPTION
1957: WHEN NO_DATA_FOUND

Line 1977: FROM pay_batch_lines pbl, pay_batch_headers pbh

1973: IF l_batch_name IS NOT NULL
1974: THEN
1975: SELECT COUNT (pbl.batch_line_id)
1976: INTO l_batch_lines
1977: FROM pay_batch_lines pbl, pay_batch_headers pbh
1978: WHERE pbh.batch_name = l_batch_name
1979: AND pbl.batch_id = pbh.batch_id;
1980:
1981: --