APPS.PAY_BTL_BUS dependencies on PAY_BATCH_HEADERS

Line 374: , pay_batch_headers bth

370: cursor csr_sec_grp is
371: select pbg.security_group_id
372: from per_business_groups pbg
373: , pay_batch_lines btl
374: , pay_batch_headers bth
375: where btl.batch_line_id = p_batch_line_id
376: and bth.batch_id = btl.batch_id
377: and pbg.business_group_id = bth.business_group_id;
378: --

Line 441: , pay_batch_headers bth

437: cursor csr_leg_code is
438: select pbg.legislation_code
439: from per_business_groups pbg
440: , pay_batch_lines btl
441: , pay_batch_headers bth
442: where btl.batch_line_id = p_batch_line_id
443: and bth.batch_id = btl.batch_id
444: and pbg.business_group_id = bth.business_group_id;
445: --

Line 630: -- it exists in pay_batch_headers.

626: --
627: -- Desciption :
628: --
629: -- Validate that on insert BATCH_ID is not null and that
630: -- it exists in pay_batch_headers.
631: --
632: --
633: -- Pre-conditions :
634: --

Line 663: from pay_batch_headers bth

659: l_dummy number;
660: --
661: cursor csr_batch_id_exists is
662: select null
663: from pay_batch_headers bth
664: where bth.batch_id = p_batch_id;
665: --
666: begin
667: hr_utility.set_location('Entering:'||l_proc, 1);

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

684: if (p_batch_line_id is null) then
685: --
686: hr_utility.set_location(l_proc, 10);
687: --
688: -- Check that the batch_id is in the pay_batch_headers.
689: --
690: open csr_batch_id_exists;
691: fetch csr_batch_id_exists into l_dummy;
692: if csr_batch_id_exists%notfound then

Line 751: from pay_batch_headers bth

747: l_api_updating boolean;
748: --
749: cursor csr_batch_header_status is
750: select bth.batch_status
751: from pay_batch_headers bth
752: where bth.batch_id = p_batch_id;
753: --
754: cursor csr_batch_line_asg is
755: select null

Line 763: l_batch_header_status pay_batch_headers.batch_status%TYPE;

759: or btl.assignment_id = p_assignment_id)
760: and ((btl.assignment_number is null and p_assignment_number is null)
761: or btl.assignment_number = p_assignment_number);
762: --
763: l_batch_header_status pay_batch_headers.batch_status%TYPE;
764: l_dummy number;
765: begin
766: hr_utility.set_location('Entering:'||l_proc, 1);
767: --

Line 1050: cursor csr_bg_id(c_batch_id pay_batch_headers.batch_id%type) is

1046: p_rec in pay_btl_shd.g_rec_type
1047: )
1048: is
1049:
1050: cursor csr_bg_id(c_batch_id pay_batch_headers.batch_id%type) is
1051: select pbh.business_group_id
1052: from pay_batch_headers pbh
1053: where pbh.batch_id = c_batch_id;
1054:

Line 1052: from pay_batch_headers pbh

1048: is
1049:
1050: cursor csr_bg_id(c_batch_id pay_batch_headers.batch_id%type) is
1051: select pbh.business_group_id
1052: from pay_batch_headers pbh
1053: where pbh.batch_id = c_batch_id;
1054:
1055: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is
1056: select cost_allocation_structure

Line 1055: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is

1051: select pbh.business_group_id
1052: from pay_batch_headers pbh
1053: where pbh.batch_id = c_batch_id;
1054:
1055: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is
1056: select cost_allocation_structure
1057: from per_business_groups
1058: where business_group_id= c_business_group_id;
1059:

Line 1060: l_business_group_id pay_batch_headers.business_group_id%type;

1056: select cost_allocation_structure
1057: from per_business_groups
1058: where business_group_id= c_business_group_id;
1059:
1060: l_business_group_id pay_batch_headers.business_group_id%type;
1061: l_id_flex_num pay_cost_allocation_keyflex.id_flex_num%type;
1062: l_segments pay_btl_shd.segment_value;
1063:
1064: