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 214: per_assignment_status_types typ

210: CURSOR c_assignments(p_resource_id In Number,
211: p_evaluation_date In Date) IS
212: SELECT pas.ASSIGNMENT_ID
213: FROM PER_ALL_ASSIGNMENTS_F pas,
214: per_assignment_status_types typ
215: WHERE pas.PERSON_ID = p_resource_id
216: AND pas.ASSIGNMENT_TYPE in ('E','C')
217: AND pas.PRIMARY_FLAG = 'Y'
218: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID

Line 267: per_assignment_status_types typ

263: SELECT pas.ASSIGNMENT_ID,
264: pas.payroll_id,
265: pas.business_group_id
266: FROM PER_ASSIGNMENTS_F2 pas,
267: per_assignment_status_types typ
268: WHERE pas.PERSON_ID = p_resource_id
269: AND pas.ASSIGNMENT_TYPE in ('E','C')
270: -- AND pas.PRIMARY_FLAG = 'Y'
271: AND pas.ASSIGNMENT_STATUS_TYPE_ID = typ.ASSIGNMENT_STATUS_TYPE_ID