APPS.CSTPPIPV dependencies on CST_AP_VARIANCE_HEADERS

Line 553: FROM cst_ap_variance_headers cavh,

549: 80,
550: cavh.var_amount,
551: p_adj_account,
552: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id)
553: FROM cst_ap_variance_headers cavh,
554: mtl_system_items msi
555: WHERE cavh.batch_id = l_batch_id
556: AND cavh.var_amount <> 0
557: AND cavh.inventory_item_id = msi.inventory_item_id

Line 1321: FROM cst_ap_variance_headers cavh,

1317: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id),
1318: pda.po_header_id,
1319: pda.po_line_id,
1320: p_adj_account
1321: FROM cst_ap_variance_headers cavh,
1322: po_distributions_all pda,
1323: wip_operation_resources wor,
1324: org_acct_periods oap,
1325: mtl_parameters mp,

Line 1737: INSERT INTO cst_ap_variance_headers

1733: END IF;
1734:
1735: l_stmt_num := 20;
1736:
1737: INSERT INTO cst_ap_variance_headers
1738: (
1739: variance_header_id,
1740: po_distribution_id,
1741: var_amount,

Line 1758: SELECT cst_ap_variance_headers_s.nextval, -- header_id

1754: program_update_date,
1755: last_update_login
1756: )
1757: (
1758: SELECT cst_ap_variance_headers_s.nextval, -- header_id
1759: c_cavl_po_rec.po_distribution_id, -- po_dist
1760: c_cavl_po_rec.var_amount, -- var_amount
1761: p_organization_id,
1762: p_inventory_item_id,

Line 1798: FROM cst_ap_variance_headers cavh

1794:
1795: UPDATE cst_ap_variance_lines cavl
1796: SET cavl.variance_header_id =
1797: (SELECT cavh.variance_header_id
1798: FROM cst_ap_variance_headers cavh
1799: WHERE cavh.batch_id = cavl.batch_id
1800: AND cavh.po_distribution_id = cavl.po_distribution_id
1801: AND cavh.cost_group_id = cavl.cost_group_id
1802: )

Line 1806: FROM cst_ap_variance_headers cavh2

1802: )
1803: WHERE cavl.batch_id = p_batch_id
1804: AND EXISTS
1805: ( SELECT 'X'
1806: FROM cst_ap_variance_headers cavh2
1807: WHERE cavh2.batch_id = p_batch_id
1808: AND cavh2.po_distribution_id = cavl.po_distribution_id
1809: AND cavh2.cost_group_id = cavl.cost_group_id
1810: );

Line 2011: SELECT cst_ap_variance_headers_s.nextval

2007: FROM cst_ap_variance_lines cavl
2008: WHERE cavl.batch_id = p_batch_id
2009: AND cavl.po_distribution_id = p_po_distribution_id;
2010:
2011: SELECT cst_ap_variance_headers_s.nextval
2012: INTO l_header_id
2013: FROM dual;
2014:
2015:

Line 2019: cst_ap_variance_headers(

2015:
2016: l_stmt_num := 25;
2017:
2018: INSERT INTO
2019: cst_ap_variance_headers(
2020: variance_header_id,
2021: po_distribution_id,
2022: var_amount,
2023: organization_id,