DBA Data[Home] [Help]

APPS.PA_ADMIN_EXT dependencies on PA_ONLINE_EXP

Line 15: WHERE SUPERVISOR_ID = pa_online_exp.GetAdminPersonId

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
19: AND A.ORGANIZATION_ID IS NOT NULL

Line 50: WHERE SUPERVISOR_ID = pa_online_exp.GetAdminPersonId

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)
54: AND A.PRIMARY_FLAG = 'Y'