APPS.PA_ADMIN_EXT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 14: , PER_ASSIGNMENT_STATUS_TYPES AST

10: BEGIN
11: SELECT COUNT(*)
12: INTO X_dummy
13: FROM PER_ASSIGNMENTS_F A
14: , PER_ASSIGNMENT_STATUS_TYPES AST
15: WHERE SUPERVISOR_ID = pa_online_exp.GetAdminPersonId
16: AND A.PRIMARY_FLAG = 'Y'
17: AND A.ASSIGNMENT_TYPE IN ('E','C')
18: AND A.JOB_ID IS NOT NULL

Line 49: , PER_ASSIGNMENT_STATUS_TYPES AST

45:
46: SELECT COUNT(*)
47: INTO X_dummy
48: FROM PER_ASSIGNMENTS_F A
49: , PER_ASSIGNMENT_STATUS_TYPES AST
50: WHERE SUPERVISOR_ID = pa_online_exp.GetAdminPersonId
51: AND (trunc(effective_start_date) between x_date and X_ending_date or
52: trunc(effective_end_date) between X_date and X_ending_date or
53: trunc(sysdate) between effective_start_date and effective_end_date)