APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on PER_ALL_ASSIGNMENTS_F
Line 550: FROM PER_ALL_ASSIGNMENTS_F paa,
546: cursor c_date
547: (p_check_date in DATE
548: ,p_resource_id in NUMBER) is
549: SELECT 'Y' 550: FROM PER_ALL_ASSIGNMENTS_F paa, 551: per_assignment_status_types typ
552: WHERE paa.PERSON_ID = p_resource_id
553: AND paa.ASSIGNMENT_TYPE = 'E'
554: AND paa.PRIMARY_FLAG = 'Y'