APPS.PAY_PAYWSDAS_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 239: from HR_ASSIGNMENT_SET_AMENDMENTS

235: procedure check_amendment_exists(p_assignment_set_id in number) is
236: --
237: cursor C_AMD2 is
238: select null
239: from HR_ASSIGNMENT_SET_AMENDMENTS
240: where ASSIGNMENT_SET_ID = p_assignment_set_id;
241: --
242: dummy varchar2(1);
243: --

Line 265: from HR_ASSIGNMENT_SET_AMENDMENTS

261: p_rowid in varchar2) is
262: --
263: cursor C_AMD5 is
264: select null
265: from HR_ASSIGNMENT_SET_AMENDMENTS
266: where ASSIGNMENT_SET_ID = p_assignment_set_id
267: and ASSIGNMENT_ID = p_assignment_id
268: and ( p_rowid is null
269: or p_rowid is not null and p_rowid <> ROWID);

Line 292: from HR_ASSIGNMENT_SET_AMENDMENTS HR1,

288: procedure check_amd_inc_exc(p_assignment_set_id in number) is
289: --
290: cursor C_AMD3 is
291: select null
292: from HR_ASSIGNMENT_SET_AMENDMENTS HR1,
293: HR_ASSIGNMENT_SET_AMENDMENTS HR2
294: where HR1.ASSIGNMENT_SET_ID = p_assignment_set_id
295: and HR1.ASSIGNMENT_SET_ID = HR2.ASSIGNMENT_SET_ID
296: and HR1.INCLUDE_OR_EXCLUDE <> HR2.INCLUDE_OR_EXCLUDE;

Line 293: HR_ASSIGNMENT_SET_AMENDMENTS HR2

289: --
290: cursor C_AMD3 is
291: select null
292: from HR_ASSIGNMENT_SET_AMENDMENTS HR1,
293: HR_ASSIGNMENT_SET_AMENDMENTS HR2
294: where HR1.ASSIGNMENT_SET_ID = p_assignment_set_id
295: and HR1.ASSIGNMENT_SET_ID = HR2.ASSIGNMENT_SET_ID
296: and HR1.INCLUDE_OR_EXCLUDE <> HR2.INCLUDE_OR_EXCLUDE;
297: --

Line 321: from HR_ASSIGNMENT_SET_AMENDMENTS

317: p_rowid in varchar2) is
318: --
319: cursor C_AMD4 is
320: select null
321: from HR_ASSIGNMENT_SET_AMENDMENTS
322: where ASSIGNMENT_SET_ID = p_assignment_set_id
323: and INCLUDE_OR_EXCLUDE <> p_include_exclude
324: and ( p_rowid is null
325: or p_rowid is not null and p_rowid <> ROWID);