DBA Data[Home] [Help]

APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 147: from per_assignment_status_types_tl astpl,

143: raise invalid_status_badjust;
144: else
145: select astp.assignment_status_type_id
146: into l_ass_status_typ_id
147: from per_assignment_status_types_tl astpl,
148: per_assignment_status_types astp
149: where astpl.assignment_status_type_id = astp.assignment_status_type_id
150: and UPPER(astpl.user_status) = UPPER(p_assignment_status)
151: and nvl(astp.business_group_id,nvl(p_business_group_id,0))