DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_MONTHLY dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 166: from pay_cost_allocation_keyflex cak, ben_actl_prem_f apr

162: segment7, segment8, segment9, segment10, segment11, segment12,
163: segment13, segment14, segment15, segment16, segment17, segment18,
164: segment19, segment20, segment21, segment22, segment23, segment24,
165: segment25, segment26, segment27, segment28, segment29, segment30
166: from pay_cost_allocation_keyflex cak, ben_actl_prem_f apr
167: where apr.actl_prem_id = p_actl_prem_id
168: and apr.cost_allocation_keyflex_id = cak.cost_allocation_keyflex_id
169: and apr.business_group_id+0 = p_business_group_id
170: and p_effective_date between

Line 211: l_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;

207: l_asg csr_asg%rowtype;
208:
209: l_effective_date date;
210: l_session_id number;
211: l_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE;
212: l_cnt number;
213: l_cnt2 number;
214: l_outputs ff_exec.outputs_t;
215: