APPS.PAY_PST_UTILS dependencies on HR_PUMP_BATCH_LINES

Line 38: FROM hr_pump_batch_lines bl

34: SELECT SUM(DECODE(bl.line_status,'U',1,0)),
35: SUM(DECODE(bl.line_status,'V',1,0)),
36: SUM(DECODE(bl.line_status,'E',1,0)),
37: SUM(DECODE(bl.line_status,'C',1,0))
38: FROM hr_pump_batch_lines bl
39: WHERE bl.batch_id = cp_batch_id;
40: --
41: CURSOR csr_except(cp_batch_id IN NUMBER) IS
42: SELECT be.exception_text

Line 194: FROM hr_pump_batch_lines bl,hr_api_modules am

190: SUM(DECODE(bl.line_status,'U',1,0)),
191: SUM(DECODE(bl.line_status,'V',1,0)),
192: SUM(DECODE(bl.line_status,'E',1,0)),
193: SUM(DECODE(bl.line_status,'C',1,0))
194: FROM hr_pump_batch_lines bl,hr_api_modules am
195: WHERE bl.batch_id = cp_batch_id
196: AND bl.api_module_id = cp_api_id
197: AND am.api_module_id = bl.api_module_id
198: GROUP BY