eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_POS_BGT_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 108: -- Added reference to effective dates on per_assignment_budget_values_f and changed name to

104: -- Changed datatype from VARCHAR2 to DATE for X_START_DATE and removed call to TO_DATE()
105: -- function from Cursor. PASHUN. 31-10-1997. BUG : 572545.
106: --
107: --
108: -- Added reference to effective dates on per_assignment_budget_values_f and changed name to
109: -- per_assignment_budget_values_f.
110: -- SASmith 31-MAR-1998.
111: --
112: PROCEDURE GET_PERIOD_START(X_PERIOD_START IN OUT NUMBER,

Line 109: -- per_assignment_budget_values_f.

105: -- function from Cursor. PASHUN. 31-10-1997. BUG : 572545.
106: --
107: --
108: -- Added reference to effective dates on per_assignment_budget_values_f and changed name to
109: -- per_assignment_budget_values_f.
110: -- SASmith 31-MAR-1998.
111: --
112: PROCEDURE GET_PERIOD_START(X_PERIOD_START IN OUT NUMBER,
113: X_POSITION_ID NUMBER,

Line 119: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,

115: X_START_DATE DATE,
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

Line 160: -- per_assignment_budget_values_f.

156: -- function from Cursor. PASHUN. 31-10-1997. BUG : 572545.
157: --
158: --
159: -- Added reference to effective dates on per_assignment_budget_values and changed name to
160: -- per_assignment_budget_values_f.
161: -- SASMITH 31-MAR-1998.
162: --
163:
164: PROCEDURE GET_PERIOD_END(X_PERIOD_END IN OUT NUMBER,

Line 171: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,

167: X_END_DATE DATE,
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

Line 230: -- per_assignment_budget_values_f. Required due to the date tracking of per_assignment_budget_values.

226: --
227: --
228: --
229: -- Added reference to effective dates on per_assignment_budget_values and changed name to
230: -- per_assignment_budget_values_f. Required due to the date tracking of per_assignment_budget_values.
231: -- Ensure that the correct assignment budget value is being picked up for the assignment as this may
232: -- be used further down to determine the number of starters (values).
233: -- NOTE : As this table is now date tracked there can be many ABV rows to one assignment row.
234: -- SASMITH 31-MAR-1998.

Line 247: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,

243: X_UNIT VARCHAR2) IS
244: CURSOR C IS
245: SELECT A.ASSIGNMENT_ID, A.POSITION_ID,
246: A.EFFECTIVE_START_DATE, A.EFFECTIVE_END_DATE, ABV.VALUE
247: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,
248: PER_ASSIGNMENTS_F A
249: WHERE A.POSITION_ID = X_POSITION_ID
250: AND A.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
251: AND A.EFFECTIVE_START_DATE <= X_END_DATE

Line 352: -- per_assignment_budget_values_f. Required due to the date tracking of per_assignment_budget_values.

348: --
349: --
350: --
351: -- Added reference to effective dates on per_assignment_budget_values and changed name to
352: -- per_assignment_budget_values_f. Required due to the date tracking of per_assignment_budget_values.
353: -- Ensure that the correct assignment budget value is being picked up for the assignment as this may
354: -- be used further down to determine the number of leavers (values).
355: -- NOTE : As this table is now date tracked there can be many ABV rows to one assignment row.
356: -- SASMITH 31-MAR-1998.

Line 372: FROM PER_ASSIGNMENT_BUDGET_VALUES_F ABV,

368:
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