APPS.PER_POS_BGT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 99: -- Added join to per_assignment_status_types to filter out terminated

95: --
96: -- PROCEDURE GET_PERIOD_START: Obtain the count as of the start date for the
97: -- selected period.
98: --
99: -- Added join to per_assignment_status_types to filter out terminated
100: -- assignments. RMF 14.11.94.
101: --
102: --
103: --

Line 120: PER_ASSIGNMENT_STATUS_TYPES AST,

116: X_UNIT VARCHAR2) IS
117: CURSOR C IS
118: SELECT NVL(SUM(ABV.VALUE),0)
119: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
120: PER_ASSIGNMENT_STATUS_TYPES AST,
121: PER_ASSIGNMENTS_F A
122: WHERE A.POSITION_ID = X_POSITION_ID
123: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
124: AND X_START_DATE BETWEEN A.EFFECTIVE_START_DATE AND

Line 150: -- Added join to per_assignment_status_types to filter out terminated

146: --
147: -- PROCEDURE GET_PERIOD_END: Obtain the count as of the end date for the
148: -- selected period.
149: --
150: -- Added join to per_assignment_status_types to filter out terminated
151: -- assignments. RMF 14.11.94.
152: --
153: --
154: --

Line 172: PER_ASSIGNMENT_STATUS_TYPES AST,

168: X_UNIT VARCHAR2) IS
169: CURSOR C IS
170: SELECT NVL(SUM(ABV.VALUE),0)
171: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
172: PER_ASSIGNMENT_STATUS_TYPES AST,
173: PER_ASSIGNMENTS_F A
174: WHERE A.POSITION_ID = X_POSITION_ID
175: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
176: AND X_END_DATE BETWEEN A.EFFECTIVE_START_DATE AND

Line 373: PER_ASSIGNMENT_STATUS_TYPES AST,

369: CURSOR C IS
370: SELECT A.ASSIGNMENT_ID, A.POSITION_ID, AST.PER_SYSTEM_STATUS,
371: A.EFFECTIVE_START_DATE, A.EFFECTIVE_END_DATE, ABV.VALUE
372: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
373: PER_ASSIGNMENT_STATUS_TYPES AST,
374: PER_ASSIGNMENTS_F A
375: WHERE A.POSITION_ID = X_POSITION_ID
376: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
377: AND A.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID