APPS.HR_LEGISLATION dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 649: elsif l_table_name = 'PAY_STATUS_PROCESSING_RULES_F' then

645: and fff.created_by > 2
646: and fff.last_updated_by > 2
647: and replace(ltrim(rtrim(upper(fff.formula_name))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_'));
648:
649: elsif l_table_name = 'PAY_STATUS_PROCESSING_RULES_F' then
650:
651: Select 'Y' into v_exists from dual where exists(
652: select null
653: from PAY_STATUS_PROCESSING_RULES_F spr,

Line 653: from PAY_STATUS_PROCESSING_RULES_F spr,

649: elsif l_table_name = 'PAY_STATUS_PROCESSING_RULES_F' then
650:
651: Select 'Y' into v_exists from dual where exists(
652: select null
653: from PAY_STATUS_PROCESSING_RULES_F spr,
654: pay_element_types_f et,
655: per_assignment_status_types ast
656: where spr.business_group_id is null
657: and spr.element_type_id = et.element_type_id

Line 674: PAY_STATUS_PROCESSING_RULES_F spr

670:
671: Select 'Y' into v_exists from dual where exists(
672: select null
673: from PAY_FORMULA_RESULT_RULES_F frr,
674: PAY_STATUS_PROCESSING_RULES_F spr
675: where frr.business_group_id is null
676: and frr.legislation_code = p_legislation_code
677: and p_effective_date <= frr.effective_end_date
678: and p_effective_date between spr.effective_start_date and spr.effective_end_date