DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on PAY_BATCH_LINES

Line 652: FROM pay_batch_lines pbl

648:
649: CURSOR csr_batch_lines (p_batch_id IN pay_batch_headers.batch_name%TYPE)
650: IS
651: SELECT COUNT (pbl.batch_line_id)
652: FROM pay_batch_lines pbl
653: WHERE pbl.batch_id = p_batch_id;
654:
655: l_batch_lines NUMBER;
656: BEGIN

Line 724: FROM pay_batch_lines pbl, pay_batch_headers pbh

720: p_bg_id IN pay_batch_headers.business_group_id%TYPE
721: )
722: IS
723: SELECT COUNT (pbl.batch_line_id)
724: FROM pay_batch_lines pbl, pay_batch_headers pbh
725: WHERE pbl.batch_id = pbh.batch_id
726: AND pbh.business_group_id = p_bg_id
727: AND batch_reference = p_batch_reference;
728:

Line 2384: l_value pay_batch_lines.segment1%TYPE;

2380: AS
2381: l_proc proc_name;
2382:
2383: l_cost_segment_number PLS_INTEGER;
2384: l_value pay_batch_lines.segment1%TYPE;
2385: BEGIN
2386: g_debug :=hr_utility.debug_enabled;
2387: if g_debug then
2388: l_proc := g_package