DBA Data[Home] [Help]

APPS.PAY_GARN_EXEMPTION_RULES_PKG dependencies on PAY_US_GARN_EXEMPTION_RULES_F

Line 102: FROM pay_us_garn_exemption_rules_f

98: esd DATE;
99: BEGIN
100: SELECT MIN(effective_start_date)
101: INTO esd
102: FROM pay_us_garn_exemption_rules_f
103: WHERE state_code = X_State_Code
104: AND GARN_CATEGORY = X_Garn_Category;
105: IF (esd IS NOT NULL) then
106: hr_utility.set_message(801, 'PAY_51780_GER_CHK_UNI_W_DATE');