APPS.CSTPPIPV dependencies on CST_AP_VARIANCE_HEADERS

Line 577: FROM cst_ap_variance_headers cavh,

573: 80,
574: cavh.var_amount,
575: p_adj_account,
576: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id)
577: FROM cst_ap_variance_headers cavh,
578: mtl_system_items msi
579: WHERE cavh.batch_id = l_batch_id
580: AND cavh.var_amount <> 0
581: AND cavh.inventory_item_id = msi.inventory_item_id

Line 1367: FROM cst_ap_variance_headers cavh,

1363: 'PO Distribution: '|| TO_CHAR (cavh.po_distribution_id),
1364: pda.po_header_id,
1365: pda.po_line_id,
1366: p_adj_account
1367: FROM cst_ap_variance_headers cavh,
1368: po_distributions_all pda,
1369: wip_operation_resources wor,
1370: org_acct_periods oap,
1371: mtl_parameters mp,

Line 1803: INSERT INTO cst_ap_variance_headers

1799: END IF;
1800:
1801: l_stmt_num := 20;
1802:
1803: INSERT INTO cst_ap_variance_headers
1804: (
1805: variance_header_id,
1806: po_distribution_id,
1807: var_amount,

Line 1824: SELECT cst_ap_variance_headers_s.nextval, -- header_id

1820: program_update_date,
1821: last_update_login
1822: )
1823: (
1824: SELECT cst_ap_variance_headers_s.nextval, -- header_id
1825: c_cavl_po_rec.po_distribution_id, -- po_dist
1826: c_cavl_po_rec.var_amount, -- var_amount
1827: p_organization_id,
1828: p_inventory_item_id,

Line 1864: FROM cst_ap_variance_headers cavh

1860:
1861: UPDATE cst_ap_variance_lines cavl
1862: SET cavl.variance_header_id =
1863: (SELECT cavh.variance_header_id
1864: FROM cst_ap_variance_headers cavh
1865: WHERE cavh.batch_id = cavl.batch_id
1866: AND cavh.po_distribution_id = cavl.po_distribution_id
1867: AND cavh.cost_group_id = cavl.cost_group_id
1868: )

Line 1872: FROM cst_ap_variance_headers cavh2

1868: )
1869: WHERE cavl.batch_id = p_batch_id
1870: AND EXISTS
1871: ( SELECT 'X'
1872: FROM cst_ap_variance_headers cavh2
1873: WHERE cavh2.batch_id = p_batch_id
1874: AND cavh2.po_distribution_id = cavl.po_distribution_id
1875: AND cavh2.cost_group_id = cavl.cost_group_id
1876: );

Line 2097: SELECT cst_ap_variance_headers_s.nextval

2093: FROM cst_ap_variance_lines cavl
2094: WHERE cavl.batch_id = p_batch_id
2095: AND cavl.po_distribution_id = p_po_distribution_id;
2096:
2097: SELECT cst_ap_variance_headers_s.nextval
2098: INTO l_header_id
2099: FROM dual;
2100:
2101:

Line 2105: cst_ap_variance_headers(

2101:
2102: l_stmt_num := 25;
2103:
2104: INSERT INTO
2105: cst_ap_variance_headers(
2106: variance_header_id,
2107: po_distribution_id,
2108: var_amount,
2109: organization_id,