APPS.PER_DISPLAY_ACCRUAL_BALANCE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 52: per_assignment_status_types typ

48: SELECT pas.ASSIGNMENT_ID,
49: pas.payroll_id,
50: pas.business_group_id
51: FROM PER_ALL_ASSIGNMENTS_F pas,
52: per_assignment_status_types typ
53: WHERE pas.PERSON_ID = p_resource_id
54: AND pas.ASSIGNMENT_TYPE in ('E','C')
55: AND pas.PRIMARY_FLAG = 'Y'
56: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 207: per_assignment_status_types typ

203: CURSOR c_assignments(p_resource_id In Number,
204: p_evaluation_date In Date) IS
205: SELECT pas.ASSIGNMENT_ID
206: FROM PER_ALL_ASSIGNMENTS_F pas,
207: per_assignment_status_types typ
208: WHERE pas.PERSON_ID = p_resource_id
209: AND pas.ASSIGNMENT_TYPE in ('E','C')
210: AND pas.PRIMARY_FLAG = 'Y'
211: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 260: per_assignment_status_types typ

256: SELECT pas.ASSIGNMENT_ID,
257: pas.payroll_id,
258: pas.business_group_id
259: FROM PER_ALL_ASSIGNMENTS_F pas,
260: per_assignment_status_types typ
261: WHERE pas.PERSON_ID = p_resource_id
262: AND pas.ASSIGNMENT_TYPE in ('E','C')
263: AND pas.PRIMARY_FLAG = 'Y'
264: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID