APPS.GMA_PURGE_ENGINE dependencies on PO_RECV_HST

Line 2051: cursor c2 (ppo_id po_recv_hst.po_id%type) is

2047: RECV_LINE_ID (PK) This column may contain a receipt or a return line number: Recpt: fk to po_recv_dtl; Rtrn: fk to po_rtrn_dtl.
2048: DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.
2049: */
2050:
2051: cursor c2 (ppo_id po_recv_hst.po_id%type) is
2052: select count(*)
2053: from po_recv_hst
2054: where po_id = ppo_id
2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)

Line 2053: from po_recv_hst

2049: */
2050:
2051: cursor c2 (ppo_id po_recv_hst.po_id%type) is
2052: select count(*)
2053: from po_recv_hst
2054: where po_id = ppo_id
2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)
2056: and gl_posted_ind <> 1;
2057:

Line 2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)

2051: cursor c2 (ppo_id po_recv_hst.po_id%type) is
2052: select count(*)
2053: from po_recv_hst
2054: where po_id = ppo_id
2055: and RECV_LINE_ID not in (SELECT RECV_LINE_ID from po_recv_hst where po_id=ppo_id and delete_mark=1)
2056: and gl_posted_ind <> 1;
2057:
2058: MINPO po_ordr_hdr.po_no%type;
2059: MAXPO po_ordr_hdr.po_no%type;