DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_MONTHLY dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 172: from pay_cost_allocation_keyflex cak, ben_actl_prem_f apr

168: segment7, segment8, segment9, segment10, segment11, segment12,
169: segment13, segment14, segment15, segment16, segment17, segment18,
170: segment19, segment20, segment21, segment22, segment23, segment24,
171: segment25, segment26, segment27, segment28, segment29, segment30
172: from pay_cost_allocation_keyflex cak, ben_actl_prem_f apr
173: where apr.actl_prem_id = p_actl_prem_id
174: and apr.cost_allocation_keyflex_id = cak.cost_allocation_keyflex_id
175: and apr.business_group_id+0 = p_business_group_id
176: and p_effective_date between

Line 217: l_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;

213: l_asg csr_asg%rowtype;
214:
215: l_effective_date date;
216: l_session_id number;
217: l_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
218: l_cnt number;
219: l_cnt2 number;
220: l_outputs ff_exec.outputs_t;
221: