DBA Data[Home] [Help]

APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_RCV_CRITERIA_V

Line 265: from qa_skiplot_rcv_criteria_val_v qsrc

261: RETURN VARCHAR2 IS
262:
263: cursor rcv_criteria (x_org_id number) is
264: select count(*)
265: from qa_skiplot_rcv_criteria_val_v qsrc
266: where qsrc.organization_id = x_org_id and
267: trunc(sysdate) between nvl(trunc(qsrc.effective_from), trunc(sysdate))
268: and nvl(trunc(qsrc.effective_to), trunc(sysdate));
269:

Line 943: from qa_skiplot_rcv_criteria_v

939: manufacturer_name,
940: project_number,
941: task_number,
942: wf_role_name
943: from qa_skiplot_rcv_criteria_v
944: where criteria_id = x_criteria_id;
945:
946: cursor char_names is
947: select name