DBA Data[Home] [Help]

APPS.PQP_GB_PSI_HRS_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 121: FROM per_assignment_status_types

117: CURSOR csr_get_asg_sts_dtls(c_per_system_status VARCHAR2)
118: IS
119: SELECT assignment_status_type_id, default_flag, active_flag, primary_flag
120: ,user_status, pay_system_status, per_system_status
121: FROM per_assignment_status_types
122: WHERE per_system_status = c_per_system_status
123: AND (
124: (business_group_id = g_business_group_id)
125: OR (