APPS.PAY_PAYWSDAS_PKG dependencies on HR_ASSIGNMENT_SET_CRITERIA

Line 214: from HR_ASSIGNMENT_SET_CRITERIA

210: function no_criteria_exists(p_assignment_set_id in number) return boolean is
211: --
212: cursor C_CR2 is
213: select null
214: from HR_ASSIGNMENT_SET_CRITERIA
215: where ASSIGNMENT_SET_ID = p_assignment_set_id;
216: --
217: dummy varchar2(1);
218: --

Line 348: from HR_ASSIGNMENT_SET_CRITERIA

344: p_line_no in number default 0) is
345: --
346: cursor C_AS2 is
347: select null
348: from HR_ASSIGNMENT_SET_CRITERIA
349: where ASSIGNMENT_SET_ID = p_assignment_set_id
350: and LINE_NO <> p_line_no;
351: --
352: dummy varchar2(1);

Line 455: from HR_ASSIGNMENT_SET_CRITERIA

451: p_rowid in varchar2) is
452: --
453: cursor C_LN1 is
454: select 'x'
455: from HR_ASSIGNMENT_SET_CRITERIA
456: where ASSIGNMENT_SET_ID = p_assignment_set_id
457: and LINE_NO = p_line_no
458: and (p_rowid is null
459: or p_rowid is not null and p_rowid <> ROWID);

Line 497: from HR_ASSIGNMENT_SET_CRITERIA

493: --
494: cursor C_MMAX1 is
495: select ((FLOOR(max(LINE_NO) / 10)) + 1) * 10,
496: min(LINE_NO)
497: from HR_ASSIGNMENT_SET_CRITERIA
498: where ASSIGNMENT_SET_ID = p_assignment_set_id;
499: --
500: begin
501: --