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_JP_PRE_TAX_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 330: FROM HR_ASSIGNMENT_SET_AMENDMENTS

326: l_dummy NUMBER;
327: BEGIN
328: SELECT 0
329: INTO l_dummy
330: FROM HR_ASSIGNMENT_SET_AMENDMENTS
331: WHERE ASSIGNMENT_SET_ID = p_assignment_set_id
332: AND INCLUDE_OR_EXCLUDE = 'I'
333: AND ROWNUM = 1;
334: RETURN l_dummy;

Line 352: l_inc_or_exc HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

348: p_assignment_id IN NUMBER,
349: p_assignment_set_id IN NUMBER
350: )
351: RETURN VARCHAR2 IS
352: l_inc_or_exc HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
353: --
354: BEGIN
355: SELECT INCLUDE_OR_EXCLUDE
356: INTO l_inc_or_exc

Line 357: FROM HR_ASSIGNMENT_SET_AMENDMENTS

353: --
354: BEGIN
355: SELECT INCLUDE_OR_EXCLUDE
356: INTO l_inc_or_exc
357: FROM HR_ASSIGNMENT_SET_AMENDMENTS
358: WHERE ASSIGNMENT_ID = p_assignment_id
359: AND ASSIGNMENT_SET_ID = p_assignment_set_id;
360: --
361: RETURN l_inc_or_exc;

Line 382: l_amendment_flag HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

378: p_effective_date IN DATE,
379: p_dummy IN NUMBER) RETURN BOOLEAN
380: IS
381: l_result BOOLEAN;
382: l_amendment_flag HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
383: --
384: BEGIN
385: IF (p_dummy = 1)THEN
386: l_amendment_flag := get_amendment_flag(p_assignment_id,p_assignment_set_id);

Line 420: FROM HR_ASSIGNMENT_SET_AMENDMENTS

416: --
417: BEGIN
418: SELECT 1
419: INTO l_dummy
420: FROM HR_ASSIGNMENT_SET_AMENDMENTS
421: WHERE ASSIGNMENT_SET_ID = p_assignment_set_id
422: AND ROWNUM = 1
423: AND EXISTS ( select null from hr_assignment_sets
424: where ASSIGNMENT_SET_ID = p_assignment_set_id