APPS.PQP_PERASGADD_RIW dependencies on PAY_LEGISLATION_RULES

Line 11032: from pay_legislation_rules plr,

11028: --and still the user has entered the values then we have to set
11029: --the values to null so that the api does not throw an error.
11030: Begin
11031: select plr.rule_mode into id_flex_num
11032: from pay_legislation_rules plr,
11033: per_business_groups_perf pgr
11034: where plr.legislation_code = pgr.legislation_code
11035: and pgr.business_group_id = p_business_group_id
11036: and plr.rule_type = 'S'

Line 11047: from pay_legislation_rules plr2

11043: and fsav.segment_attribute_type = 'ASSIGNMENT'
11044: and fsav.attribute_value = 'Y')
11045: and exists
11046: (select 1
11047: from pay_legislation_rules plr2
11048: where plr2.legislation_code = plr.legislation_code
11049: and plr2.rule_type = 'SDL'
11050: and plr2.rule_mode = 'A') ;
11051: Exception