DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 175: FROM per_assignment_status_types

171: CURSOR csr_get_asg_sts_dtls(c_per_system_status VARCHAR2)
172: IS
173: SELECT assignment_status_type_id, default_flag, active_flag, primary_flag
174: ,user_status, pay_system_status, per_system_status
175: FROM per_assignment_status_types
176: WHERE per_system_status = c_per_system_status
177: AND (
178: (business_group_id = g_business_group_id)
179: OR (