DBA Data[Home] [Help]

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'