DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_ACTL_PREM_F

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 1021: from ben_actl_prem_f apr,

1017: apr.lwr_lmt_calc_rl, apr.lwr_lmt_val,
1018: apr.upr_lmt_calc_rl, apr.upr_lmt_val,
1019: apr.cr_lkbk_val,apr.cr_lkbk_crnt_py_only_flag,
1020: ppe.effective_start_date
1021: from ben_actl_prem_f apr,
1022: ben_per_in_ler pil,
1023: ben_prtt_prem_f ppe
1024: where apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplo.pkb
1025: and apr.business_group_id+0 = p_business_group_id