APPS.PAY_BTL_SHD dependencies on PAY_BATCH_HEADERS

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

721: p_ccid in out nocopy number,
722: p_concat_segments_out out nocopy varchar2
723: ) is
724:
725: cursor csr_bg_id(c_batch_id pay_batch_headers.batch_id%type) is
726: select pbh.business_group_id
727: from pay_batch_headers pbh
728: where pbh.batch_id = c_batch_id;
729:

Line 727: from pay_batch_headers pbh

723: ) is
724:
725: cursor csr_bg_id(c_batch_id pay_batch_headers.batch_id%type) is
726: select pbh.business_group_id
727: from pay_batch_headers pbh
728: where pbh.batch_id = c_batch_id;
729:
730: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is
731: select cost_allocation_structure

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

726: select pbh.business_group_id
727: from pay_batch_headers pbh
728: where pbh.batch_id = c_batch_id;
729:
730: cursor csr_id_flex_num(c_business_group_id pay_batch_headers.business_group_id%type)is
731: select cost_allocation_structure
732: from per_business_groups
733: where business_group_id= c_business_group_id;
734:

Line 745: l_business_group_id pay_batch_headers.business_group_id%type;

741: select concatenated_segments
742: from pay_cost_allocation_keyflex
743: where cost_allocation_keyflex_id = c_ccid;
744:
745: l_business_group_id pay_batch_headers.business_group_id%type;
746: l_ccid pay_batch_lines.cost_allocation_keyflex_id%type;
747: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
748: l_batch_id pay_batch_headers.batch_id%type;
749: l_check_segments boolean;

Line 748: l_batch_id pay_batch_headers.batch_id%type;

744:
745: l_business_group_id pay_batch_headers.business_group_id%type;
746: l_ccid pay_batch_lines.cost_allocation_keyflex_id%type;
747: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
748: l_batch_id pay_batch_headers.batch_id%type;
749: l_check_segments boolean;
750: l_proc varchar2(72) := g_package||'keyflex_comb';
751: l_id_flex_num pay_cost_allocation_keyflex.id_flex_num%type;
752: