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.PAY_GRADE_RULES_PKG dependencies on PAY_GRADE_RULES_F

Line 16: FROM PAY_GRADE_RULES_F GR

12:
13:
14: CURSOR G1 IS
15: SELECT NULL
16: FROM PAY_GRADE_RULES_F GR
17: WHERE (GR.GRADE_RULE_ID <> P_GRADE_RULE_ID_2
18: OR P_GRADE_RULE_ID_2 IS NULL)
19: AND GR.GRADE_OR_SPINAL_POINT_ID = P_GRADE_OR_SPINAL_POINT_ID
20: AND GR.RATE_TYPE = P_RATE_TYPE

Line 129: FROM PAY_GRADE_RULES_F

125: P_END_DATE DATE;
126: --
127: CURSOR c2 IS
128: SELECT ROWID
129: FROM PAY_GRADE_RULES_F
130: WHERE GRADE_RULE_ID = P_GRADE_RULE_ID;
131:
132: -- Fix for bug 2400465
133: CURSOR GRADE_DATE_TO IS

Line 153: INSERT INTO PAY_GRADE_RULES_F(GRADE_RULE_ID, EFFECTIVE_START_DATE,

149: END IF;
150: -- End of fix
151:
152:
153: INSERT INTO PAY_GRADE_RULES_F(GRADE_RULE_ID, EFFECTIVE_START_DATE,
154: EFFECTIVE_END_DATE, BUSINESS_GROUP_ID,
155: RATE_ID, GRADE_OR_SPINAL_POINT_ID, RATE_TYPE,
156: MAXIMUM, MID_VALUE, MINIMUM, SEQUENCE, VALUE,
157: REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 191: UPDATE PAY_GRADE_RULES_F

187: P_PROGRAM_UPDATE_DATE DATE,
188: P_CURRENCY_CODE VARCHAR2)
189: IS
190: BEGIN
191: UPDATE PAY_GRADE_RULES_F
192: SET GRADE_RULE_ID = P_GRADE_RULE_ID,
193: EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE, EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
194: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
195: RATE_TYPE = P_RATE_TYPE,

Line 214: DELETE FROM PAY_GRADE_RULES_F

210: END UPDATE_ROW;
211: --
212: PROCEDURE DELETE_ROW(P_ROWID VARCHAR2) IS
213: BEGIN
214: DELETE FROM PAY_GRADE_RULES_F
215: WHERE PAY_GRADE_RULES_F.ROWID = chartorowid(P_ROWID);
216: END DELETE_ROW;
217: --
218: PROCEDURE LOCK_ROW( P_ROWID VARCHAR2,

Line 215: WHERE PAY_GRADE_RULES_F.ROWID = chartorowid(P_ROWID);

211: --
212: PROCEDURE DELETE_ROW(P_ROWID VARCHAR2) IS
213: BEGIN
214: DELETE FROM PAY_GRADE_RULES_F
215: WHERE PAY_GRADE_RULES_F.ROWID = chartorowid(P_ROWID);
216: END DELETE_ROW;
217: --
218: PROCEDURE LOCK_ROW( P_ROWID VARCHAR2,
219: P_GRADE_RULE_ID NUMBER,

Line 237: CURSOR C IS SELECT * FROM PAY_GRADE_RULES_F

233: P_PROGRAM_ID NUMBER,
234: P_PROGRAM_UPDATE_DATE DATE,
235: P_CURRENCY_CODE VARCHAR2)
236: IS
237: CURSOR C IS SELECT * FROM PAY_GRADE_RULES_F
238: WHERE ROWID = chartorowid(P_ROWID)
239: FOR UPDATE OF GRADE_RULE_ID NOWAIT;
240: RECINFO C%ROWTYPE;
241: BEGIN

Line 307: from pay_rates pr, pay_grade_rules_f g

303: begin
304:
305: select pr.name
306: into l_name
307: from pay_rates pr, pay_grade_rules_f g
308: where pr.rate_id = g.rate_id
309: and g.grade_or_spinal_point_id = l_spinal_point_id
310: and p_effective_date between g.effective_start_date and g.effective_end_date
311: and g.rate_type = 'SP'; -- Fix 3401079

Line 335: l_value pay_grade_rules_f.value%TYPE;

331: FUNCTION POPULATE_VALUE(p_spinal_point_id IN NUMBER, p_effective_date IN DATE)
332:
333: RETURN VARCHAR IS
334:
335: l_value pay_grade_rules_f.value%TYPE;
336: l_rate_uom pay_rates.rate_uom%TYPE;
337: l_currency_code pay_grade_rules_f.currency_code%TYPE;
338: l_format_value varchar2(500);
339: l_spinal_point_id number := p_spinal_point_id;

Line 337: l_currency_code pay_grade_rules_f.currency_code%TYPE;

333: RETURN VARCHAR IS
334:
335: l_value pay_grade_rules_f.value%TYPE;
336: l_rate_uom pay_rates.rate_uom%TYPE;
337: l_currency_code pay_grade_rules_f.currency_code%TYPE;
338: l_format_value varchar2(500);
339: l_spinal_point_id number := p_spinal_point_id;
340:
341: begin

Line 345: from pay_grade_rules_f g, pay_rates r

341: begin
342:
343: select g.value, r.rate_uom, g.currency_code
344: into l_value, l_rate_uom, l_currency_code
345: from pay_grade_rules_f g, pay_rates r
346: where g.rate_id = r.rate_id
347: and g.grade_or_spinal_point_id = l_spinal_point_id
348: and p_effective_date between g.effective_start_date and g.effective_end_date
349: and g.rate_type = 'SP'; -- Fix 3401079

Line 389: from pay_grade_rules_f g, pay_rates r

385: begin
386:
387: select r.rate_id, r.business_group_id
388: into l_rate_id, l_bg_id
389: from pay_grade_rules_f g, pay_rates r
390: where r.rate_id = g.rate_id
391: and GRADE_OR_SPINAL_POINT_ID = l_spinal_point_id
392: and p_effective_date between g.effective_start_date and g.effective_end_date
393: and g.rate_type = 'SP'; -- Fix 3401079

Line 434: pay_grade_rules_f pgr,

430: /*
431: cursor emp_asgmnt_point is
432: select 'x'
433: from per_spinal_points psp,
434: pay_grade_rules_f pgr,
435: per_spinal_point_steps_f psps,
436: per_spinal_point_placements_f pspp
437: where psp.spinal_point_id = pgr.grade_or_spinal_point_id
438: and psp.parent_spine_id = pspp.parent_spine_id

Line 452: pay_grade_rules_f pgr,

448: -- End of fix 3774889
449: cursor emp_asgmnt_point_used is
450: select 'x'
451: from per_spinal_points psp,
452: pay_grade_rules_f pgr,
453: per_spinal_point_steps_f psps,
454: per_spinal_point_placements_f pspp
455: where psp.spinal_point_id = pgr.grade_or_spinal_point_id
456: and psp.parent_spine_id = pspp.parent_spine_id