DBA Data[Home] [Help]

APPS.PAY_EXA_FLEX dependencies on PER_BUSINESS_GROUPS

Line 1136: l_legislation_code per_business_groups.legislation_code%type;

1132: (p_rec in pay_exa_shd.g_rec_type,
1133: p_business_group_id in number) is
1134: --
1135: l_proc varchar2(72) := g_package||'kf';
1136: l_legislation_code per_business_groups.legislation_code%type;
1137: --
1138: --
1139: -- This cursor selects the legislation_code for the business group which
1140: -- will be used to switch the segment validation.

Line 1148: per_business_groups pbg

1144: --
1145: cursor lcsel is
1146: select pbg.legislation_code
1147: from pay_legislation_rules plr,
1148: per_business_groups pbg
1149: where plr.rule_type = 'E'
1150: and plr.legislation_code = pbg.legislation_code
1151: and pbg.business_group_id = p_business_group_id
1152: and plr.rule_mode = to_char(p_rec.id_flex_num);