APPS.HR_LEGISLATION dependencies on PAY_FORMULA_RESULT_RULES_F

Line 669: elsif l_table_name = 'PAY_FORMULA_RESULT_RULES_F' then

665: and replace(ltrim(rtrim(upper(et.element_name))), ' ', '_') = replace(ltrim(rtrim(upper(P_SURROGATE_KEY_NAME))), ' ', '_')
666: and replace(ltrim(rtrim(upper(spr.PROCESSING_RULE))), ' ', '_') = replace(ltrim(rtrim(upper(P_ADDL_SURROGATE_KEY_NAME1))), ' ', '_'));
667:
668:
669: elsif l_table_name = 'PAY_FORMULA_RESULT_RULES_F' then
670:
671: Select 'Y' into v_exists from dual where exists(
672: select null
673: from PAY_FORMULA_RESULT_RULES_F frr,

Line 673: from PAY_FORMULA_RESULT_RULES_F frr,

669: elsif l_table_name = 'PAY_FORMULA_RESULT_RULES_F' then
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