APPS.PAY_BCT_BUS dependencies on PAY_BATCH_HEADERS

Line 35: , pay_batch_headers bth

31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , pay_batch_control_totals bct
35: , pay_batch_headers bth
36: where bct.batch_control_id = p_batch_control_id
37: and bth.batch_id = bct.batch_id
38: and pbg.business_group_id = bth.business_group_id;
39: --

Line 102: , pay_batch_headers bth

98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups pbg
101: , pay_batch_control_totals bct
102: , pay_batch_headers bth
103: where bct.batch_control_id = p_batch_control_id
104: and bth.batch_id = bct.batch_id
105: and pbg.business_group_id = bth.business_group_id;
106: --

Line 289: -- it exists in pay_batch_headers.

285: --
286: -- Desciption :
287: --
288: -- Validate that on insert BATCH_ID is not null and that
289: -- it exists in pay_batch_headers.
290: --
291: --
292: -- Pre-conditions :
293: --

Line 322: from pay_batch_headers bth

318: l_dummy number;
319: --
320: cursor csr_batch_id_exists is
321: select null
322: from pay_batch_headers bth
323: where bth.batch_id = p_batch_id;
324: --
325: begin
326: hr_utility.set_location('Entering:'||l_proc, 1);

Line 347: -- Check that the batch_id is in the pay_batch_headers.

343: if (p_batch_control_id is null) then
344: --
345: hr_utility.set_location(l_proc, 10);
346: --
347: -- Check that the batch_id is in the pay_batch_headers.
348: --
349: open csr_batch_id_exists;
350: fetch csr_batch_id_exists into l_dummy;
351: if csr_batch_id_exists%notfound then

Line 561: p_batch_id in pay_batch_headers.batch_id%TYPE

557: -- ---------------------------------------------------------------------------
558: procedure chk_control_total
559: (p_control_type in pay_batch_control_totals.control_type%TYPE,
560: p_control_total in pay_batch_control_totals.control_total%TYPE,
561: p_batch_id in pay_batch_headers.batch_id%TYPE
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'chk_control_total';
565: l_api_updating boolean;

Line 582: pay_batch_headers pybeeh

578:
579: -- gets currency_code
580: select CURRENCY_CODE into l_curr_code
581: from PER_BUSINESS_GROUPS perbg,
582: pay_batch_headers pybeeh
583: where perbg.BUSINESS_GROUP_ID = pybeeh.BUSINESS_GROUP_ID and
584: pybeeh.batch_id = p_batch_id;
585: --
586: