DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_ACTL_PREM_F

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

1004: apr.lwr_lmt_calc_rl, apr.lwr_lmt_val,
1005: apr.upr_lmt_calc_rl, apr.upr_lmt_val,
1006: apr.cr_lkbk_val,apr.cr_lkbk_crnt_py_only_flag,
1007: ppe.effective_start_date
1008: from ben_actl_prem_f apr,
1009: ben_per_in_ler pil,
1010: ben_prtt_prem_f ppe
1011: where apr.prem_asnmt_cd = 'ENRT' -- PROC are dealt with in benprplo.pkb
1012: and apr.business_group_id+0 = p_business_group_id