DBA Data[Home] [Help]

APPS.PAY_COST_ALLOCATION_SWI dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 27: from pay_cost_allocation_keyflex

23: segment11, segment12, segment13, segment14, segment15,
24: segment16, segment17, segment18, segment19, segment20,
25: segment21, segment22, segment23, segment24, segment25,
26: segment26, segment27, segment28, segment29, segment30
27: from pay_cost_allocation_keyflex
28: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
29:
30: cursor csr_cost_structure is
31: select pbg.cost_allocation_structure

Line 141: update pay_cost_allocation_keyflex

137: hr_utility.set_location(l_proc,60);
138: /*Now update the Cost KFF entry with the concatenated segment
139: only if the existing concatenated segment is not equal to the
140: newly constructed concatenated segment(for Update)*/
141: update pay_cost_allocation_keyflex
142: set concatenated_segments = l_concatenated_segments
143: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
144: and id_flex_num = l_flex_num
145: and nvl(concatenated_segments, hr_api.g_varchar2) <> l_concatenated_segments;