DBA Data[Home] [Help]

APPS.BEN_HWF_BUS dependencies on PER_BUSINESS_GROUPS

Line 320: ,per_business_groups pbg

316: --
317: cursor c1 is
318: select null
319: from ff_formulas_f ff
320: ,per_business_groups pbg
321: where ff.formula_id = p_hrs_wkd_det_rl
322: and ff.formula_type_id = -155
323: and pbg.business_group_id = p_business_group_id
324: and nvl(ff.business_group_id, p_business_group_id) =

Line 494: ,per_business_groups pbg

490: --
491: cursor c1 is
492: select null
493: from ff_formulas_f ff
494: ,per_business_groups pbg
495: where ff.formula_id = p_rndg_rl
496: and ff.formula_type_id = -169
497: and pbg.business_group_id = p_business_group_id
498: and nvl(ff.business_group_id, p_business_group_id) =

Line 874: ,per_business_groups pbg

870: --
871: cursor c1 is
872: select null
873: from ff_formulas_f ff
874: ,per_business_groups pbg
875: where ff.formula_id = p_hrs_wkd_calc_rl
876: and ff.formula_type_id = -516
877: and pbg.business_group_id = p_business_group_id
878: and nvl(ff.business_group_id, p_business_group_id) =

Line 1491: from per_business_groups a,

1487: -- Declare cursor
1488: --
1489: cursor csr_leg_code is
1490: select a.legislation_code
1491: from per_business_groups a,
1492: ben_hrs_wkd_in_perd_fctr b
1493: where b.hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
1494: and a.business_group_id = b.business_group_id;
1495: --