DBA Data[Home] [Help]

APPS.PER_SIT_PKG dependencies on PAY_LEGISLATION_RULES

Line 533: from pay_legislation_rules pl

529: from per_person_analyses pa
530: where pa.id_flex_num = p_id_flex_num
531: and pa.business_group_id = p_business_group_id
532: and exists (select null
533: from pay_legislation_rules pl
534: where pl.rule_type = 'OSHA'
535: and pl.rule_mode = to_char(pa.id_flex_num));
536: --
537: cursor c_ada_analyses is

Line 543: from pay_legislation_rules pl

539: from per_person_analyses pa
540: where pa.id_flex_num = p_id_flex_num
541: and pa.business_group_id = p_business_group_id
542: and exists (select null
543: from pay_legislation_rules pl
544: where pl.rule_type in ('ADA_DIS_ACC','ADA_DIS')
545: and pl.rule_mode = to_char(pa.id_flex_num));
546: --
547: cursor c_other_analyses is

Line 553: from pay_legislation_rules pl

549: from per_person_analyses pa
550: where pa.id_flex_num = p_id_flex_num
551: and pa.business_group_id = p_business_group_id
552: and not exists (select null
553: from pay_legislation_rules pl
554: where pl.rule_type in ('OSHA','ADA_DIS_ACC','ADA_DIS')
555: and pl.rule_mode = to_char(pa.id_flex_num));
556: --
557: l_result boolean;