DBA Data[Home] [Help]

APPS.PA_ADMIN_EXT dependencies on PER_ASSIGNMENTS_F

Line 13: FROM PER_ASSIGNMENTS_F A

9:
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')

Line 48: FROM PER_ASSIGNMENTS_F A

44: X_date := x_ending_date - 6;
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