APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PAY_BATCH_HEADERS

Line 16: l_business_group_id pay_batch_headers.business_group_id%TYPE;

12: ,p_short_name varchar2
13: )return varchar2 is
14: --
15: l_status pay_upgrade_status.status%type;
16: l_business_group_id pay_batch_headers.business_group_id%TYPE;
17: --
18: cursor csr_bg_id is
19: select bth.business_group_id
20: from pay_batch_headers bth

Line 20: from pay_batch_headers bth

16: l_business_group_id pay_batch_headers.business_group_id%TYPE;
17: --
18: cursor csr_bg_id is
19: select bth.business_group_id
20: from pay_batch_headers bth
21: where bth.batch_id = p_batch_id
22: union all
23: select bth.business_group_id
24: from pay_batch_headers bth,

Line 24: from pay_batch_headers bth,

20: from pay_batch_headers bth
21: where bth.batch_id = p_batch_id
22: union all
23: select bth.business_group_id
24: from pay_batch_headers bth,
25: pay_batch_lines btl
26: where bth.batch_id = btl.batch_id
27: and btl.batch_line_id = p_batch_line_id;
28: --

Line 266: pay_batch_headers pbh

262: --
263: select pbg.business_group_id,pbg.legislation_code
264: into l_business_group_id,l_legislation_code
265: from per_business_groups pbg,
266: pay_batch_headers pbh
267: where pbh.batch_id = l_batch_id
268: and pbg.business_group_id = pbh.business_group_id;
269: --
270: open csr_element_type(l_element_name

Line 770: l_batch_id pay_batch_headers.batch_id%TYPE;

766: --
767: -- Declare cursors and local variables
768: --
769: l_proc varchar2(72) := g_package||'create_batch_header';
770: l_batch_id pay_batch_headers.batch_id%TYPE;
771: l_object_version_number pay_batch_headers.object_version_number%TYPE;
772: l_session_date date;
773: --
774: begin

Line 771: l_object_version_number pay_batch_headers.object_version_number%TYPE;

767: -- Declare cursors and local variables
768: --
769: l_proc varchar2(72) := g_package||'create_batch_header';
770: l_batch_id pay_batch_headers.batch_id%TYPE;
771: l_object_version_number pay_batch_headers.object_version_number%TYPE;
772: l_session_date date;
773: --
774: begin
775: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 826: from pay_batch_headers

822: into l_temp_var
823: from dual
824: where EXISTS (
825: select 1
826: from pay_batch_headers
827: where upper(batch_name) = upper(p_batch_name)
828: and business_group_id = p_business_group_id);
829:
830: hr_utility.set_message(801, 'PAY_500013_BEE_DUPL_HEADER');

Line 1810: l_object_version_number pay_batch_headers.object_version_number%TYPE;

1806: --
1807: -- Declare cursors and local variables
1808: --
1809: l_proc varchar2(72) := g_package||'update_batch_header';
1810: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1811: l_session_date date;
1812: --
1813: begin
1814: hr_utility.set_location('Entering:'|| l_proc, 10);