APPS.PQP_PERASGADD_RIW dependencies on PAY_LEGISLATION_RULES

Line 10373: from pay_legislation_rules plr,

10369: --and still the user has entered the values then we have to set
10370: --the values to null so that the api does not throw an error.
10371: Begin
10372: select plr.rule_mode into id_flex_num
10373: from pay_legislation_rules plr,
10374: per_business_groups_perf pgr
10375: where plr.legislation_code = pgr.legislation_code
10376: and pgr.business_group_id = p_business_group_id
10377: and plr.rule_type = 'S'

Line 10388: from pay_legislation_rules plr2

10384: and fsav.segment_attribute_type = 'ASSIGNMENT'
10385: and fsav.attribute_value = 'Y')
10386: and exists
10387: (select 1
10388: from pay_legislation_rules plr2
10389: where plr2.legislation_code = plr.legislation_code
10390: and plr2.rule_type = 'SDL'
10391: and plr2.rule_mode = 'A') ;
10392: Exception