APPS.PAY_SEED_SOE_PKG dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 17: from pay_legislative_field_info

13: where business_group_id = p_business_group_id;
14:
15: cursor get_profile(p_leg_code IN varchar2) is
16: select decode(rule_mode,'Y','ENABLE','DISABLE')
17: from pay_legislative_field_info
18: where legislation_code = p_leg_code
19: and field_name = 'ONLINE_SOE'
20: and rule_type = 'DISPLAY';
21:

Line 35: update pay_legislative_field_info

31: FETCH get_profile into l_rule_mode;
32:
33: IF get_profile%FOUND THEN
34: IF l_rule_mode <> p_action THEN
35: update pay_legislative_field_info
36: set rule_mode = decode(p_action,'ENABLE','Y','N')
37: where legislation_code = l_leg_code
38: and field_name = 'ONLINE_SOE'
39: and rule_type = 'DISPLAY';

Line 42: insert into pay_legislative_field_info(field_name, legislation_code,rule_type,rule_mode)

38: and field_name = 'ONLINE_SOE'
39: and rule_type = 'DISPLAY';
40: END IF;
41: ELSE
42: insert into pay_legislative_field_info(field_name, legislation_code,rule_type,rule_mode)
43: select 'ONLINE_SOE',
44: l_leg_code,
45: 'DISPLAY',
46: decode(p_action,'ENABLE','Y','N')