DBA Data[Home] [Help]

APPS.BEN_CGP_BUS dependencies on PER_BUSINESS_GROUPS

Line 118: ,per_business_groups pbg

114: --
115: cursor c1 is
116: select null
117: from ff_formulas_f ff
118: ,per_business_groups pbg
119: where ff.formula_id = p_cntng_frmr_prtt_dsge_rl
120: and ff.formula_type_id = -160
121: and pbg.business_group_id = p_business_group_id
122: and nvl(ff.business_group_id, p_business_group_id) =

Line 366: , per_business_groups pbg

362: --
363: cursor c1 is
364: select null
365: from ff_formulas_f ff
366: , per_business_groups pbg
367: where ff.formula_id = p_pymt_must_be_rcvd_rl
368: and ff.formula_type_id = -142
369: and pbg.business_group_id = p_business_group_id
370: and nvl(ff.business_group_id, p_business_group_id) =

Line 977: from per_business_groups a,

973: -- Declare cursor
974: --
975: cursor csr_leg_code is
976: select a.legislation_code
977: from per_business_groups a,
978: ben_cntng_prtn_elig_prfl_f b
979: where b.cntng_prtn_elig_prfl_id = p_cntng_prtn_elig_prfl_id
980: and a.business_group_id = b.business_group_id;
981: --