APPS.PAY_JP_ISDF_RPT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 34: l_inc_or_exc HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

30: p_assignment_id IN NUMBER,
31: p_assignment_set_id IN NUMBER
32: )
33: RETURN VARCHAR2 IS
34: l_inc_or_exc HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
35: --
36: BEGIN
37: SELECT INCLUDE_OR_EXCLUDE
38: INTO l_inc_or_exc

Line 39: FROM HR_ASSIGNMENT_SET_AMENDMENTS

35: --
36: BEGIN
37: SELECT INCLUDE_OR_EXCLUDE
38: INTO l_inc_or_exc
39: FROM HR_ASSIGNMENT_SET_AMENDMENTS
40: WHERE ASSIGNMENT_ID = p_assignment_id
41: AND ASSIGNMENT_SET_ID = p_assignment_set_id;
42: --
43: RETURN l_inc_or_exc;

Line 64: l_amendment_flag HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

60: p_effective_date IN DATE,
61: p_dummy IN NUMBER) RETURN BOOLEAN
62: IS
63: l_result BOOLEAN;
64: l_amendment_flag HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
65: --
66: BEGIN
67: IF (p_dummy = 1)THEN
68: l_amendment_flag := get_amendment_flag(p_assignment_id,p_assignment_set_id);

Line 101: FROM HR_ASSIGNMENT_SET_AMENDMENTS

97: --
98: BEGIN
99: SELECT 1
100: INTO l_dummy
101: FROM HR_ASSIGNMENT_SET_AMENDMENTS
102: WHERE ASSIGNMENT_SET_ID = p_assignment_set_id
103: AND ROWNUM = 1;
104: RETURN l_dummy;
105: EXCEPTION

Line 123: FROM HR_ASSIGNMENT_SET_AMENDMENTS

119: l_dummy NUMBER;
120: BEGIN
121: SELECT 0
122: INTO l_dummy
123: FROM HR_ASSIGNMENT_SET_AMENDMENTS
124: WHERE ASSIGNMENT_SET_ID = p_assignment_set_id
125: AND INCLUDE_OR_EXCLUDE = 'I'
126: AND ROWNUM = 1;
127: RETURN l_dummy;