APPS.HR_SCL_SHD dependencies on PAY_LEGISLATION_RULES

Line 56: from pay_legislation_rules plr,

52: -- (scl keyflex) for the specified business group
53: --
54: cursor idsel is
55: select plr.rule_mode id_flex_num
56: from pay_legislation_rules plr,
57: per_business_groups pbg
58: where pbg.business_group_id = p_business_group_id
59: and plr.legislation_code = pbg.legislation_code
60: and plr.rule_type = 'S'

Line 71: from pay_legislation_rules plr2

67: and fsav.segment_attribute_type = 'ASSIGNMENT'
68: and fsav.attribute_value = 'Y')
69: and exists
70: (select 1
71: from pay_legislation_rules plr2
72: where plr2.legislation_code = pbg.legislation_code
73: and plr2.rule_type = 'SDL'
74: and plr2.rule_mode = 'A') ;
75: --