APPS.PAY_JP_ISDF_RPT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 35: l_inc_or_exc HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

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

Line 40: FROM HR_ASSIGNMENT_SET_AMENDMENTS

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

Line 65: l_amendment_flag HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

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

Line 102: FROM HR_ASSIGNMENT_SET_AMENDMENTS

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

Line 124: FROM HR_ASSIGNMENT_SET_AMENDMENTS

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