DBA Data[Home] [Help]

APPS.PAY_PST_UTILS dependencies on HR_API_MODULES

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