APPS.PAY_BTL_SHD dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 742: from pay_cost_allocation_keyflex

738: where pbl.batch_line_id = p_batch_line_id;
739:
740: cursor csr_get_concat_segments(c_ccid pay_batch_lines.cost_allocation_keyflex_id%type) is
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;

Line 751: l_id_flex_num pay_cost_allocation_keyflex.id_flex_num%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:
753: --
754: begin
755: hr_utility.set_location('Entering:'||l_proc, 5);

Line 914: from pay_cost_allocation_keyflex

910: select segment1,segment2,segment3,segment4,segment5,segment6,segment7,segment8,segment9,
911: segment10,segment11,segment12,segment13,segment14,segment15,segment16,segment17,
912: segment18,segment19,segment20,segment21,segment22,segment23,segment24,segment25,
913: segment26,segment27,segment28,segment29,segment30
914: from pay_cost_allocation_keyflex
915: where cost_allocation_keyflex_id = c_ccid;
916:
917: l_new_segments segment_value;
918: begin