APPS.IGC_CBC_PO_GRP dependencies on PO_RELEASES

Line 660: FROM po_releases

656: ELSIF (p_document_type LIKE 'REL%') THEN
657:
658: SELECT cbc_accounting_date
659: INTO l_prev_cbc_acct_date
660: FROM po_releases
661: WHERE po_release_id = p_document_id;
662:
663: ELSIF (p_document_type LIKE 'REQ%') THEN
664:

Line 860: from po_headers po, po_releases por

856: p_document_sub_type IN ( 'SCHEDULED', 'BLANKET') THEN
857:
858: select po.cbc_accounting_date
859: into l_po_cbc_acct_date
860: from po_headers po, po_releases por
861: where po.po_header_id = por.po_header_id
862: and por.po_release_id = p_document_id;
863:
864: IF p_cbc_acct_date < l_po_cbc_acct_date THEN

Line 1037: FROM po_releases

1033:
1034: -- Cursor to get accounting date FROM PO_Rel headers for this document
1035: Cursor c_get_rel_date IS
1036: SELECT cbc_accounting_date
1037: FROM po_releases
1038: WHERE po_release_id = p_document_id ;
1039:
1040: -- Cursor to get the start date of the next open period
1041: Cursor c_next_period_date(p_sob_id NUMBER) IS

Line 1096: FROM po_releases por,

1092:
1093: -- Cursor to get the latest accounting date FROM PO's relating to the release
1094: Cursor c_rel_po_date IS
1095: SELECT poh.cbc_accounting_date
1096: FROM po_releases por,
1097: po_headers poh
1098: WHERE por.po_release_id = p_document_id
1099: AND por.po_header_id = poh.po_header_id ;
1100:

Line 1543: UPDATE po_releases

1539: ELSIF (p_document_type LIKE 'REL%')
1540: THEN
1541: -- Bug 2885953 added if statement and removed nvl from update for performance enhancement
1542: IF p_cbc_acct_date IS NOT NULL THEN
1543: UPDATE po_releases
1544: -- SET cbc_accounting_date = NVL(p_cbc_acct_date, cbc_accounting_date)
1545: SET cbc_accounting_date = p_cbc_acct_date
1546: WHERE po_release_id = p_document_id ;
1547:

Line 1667: -- po_releases r

1663: -- p.gl_encumbered_date rel_gl_date,
1664: -- p.set_of_books_id sob_id,
1665: -- r.cbc_accounting_date rel_acct_date
1666: -- From po_distributions_v p,
1667: -- po_releases r
1668: -- Where p.po_release_id = p_document_id
1669: -- And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1670: -- And p.po_release_id = r.po_release_id
1671: -- And p.requisition_header_id is not null;

Line 1678: po_releases r,

1674: pod.gl_encumbered_date rel_gl_date,
1675: pod.set_of_books_id sob_id,
1676: r.cbc_accounting_date rel_acct_date
1677: From po_distributions pod,
1678: po_releases r,
1679: po_requisition_headers porh,
1680: po_requisition_lines porl,
1681: po_req_distributions pord
1682: Where pod.po_release_id = p_document_id

Line 1698: po_releases R

1694: p.source_distribution_id,
1695: p.set_of_books_id sob_id,
1696: r.cbc_accounting_date rel_acct_date
1697: From po_distributions_v P,
1698: po_releases R
1699: Where p.po_release_id = p_document_id
1700: And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1701: And p.po_release_id = r.po_release_id;
1702: