DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on PO_LOOKUP_CODES

Line 1191: FROM po_lookup_codes plu

1187: /* Upgrade old AP transactions */
1188:
1189: Select plu.displayed_field
1190: into l_old_ipv
1191: FROM po_lookup_codes plu
1192: WHERE plu.lookup_type = 'ACCRUAL TYPE'
1193: AND plu.lookup_code = 'AP INVOICE PRICE VAR';
1194:
1195: l_stmt_num := 30;

Line 1201: FROM po_lookup_codes plu

1197: debug(' l_old_ipv :'||l_old_ipv);
1198:
1199: Select plu.displayed_field
1200: into l_old_erv
1201: FROM po_lookup_codes plu
1202: WHERE plu.lookup_type = 'ACCRUAL TYPE'
1203: AND plu.lookup_code = 'AP EXCHANGE RATE VAR';
1204:
1205: l_stmt_num := 40;

Line 2050: po_lookup_codes plc,

2046: cwo.program_id,
2047: cwo.program_update_date
2048: FROM cst_write_offs cwo,
2049: po_accrual_write_offs_all pawo,
2050: po_lookup_codes plc,
2051: rcv_receiving_sub_ledger rrs,
2052: rcv_transactions rt,
2053: xla_distribution_links xld,
2054: cst_accrual_accounts ca --BUG#7528609

Line 2132: po_lookup_codes plc,

2128: cwo.program_id,
2129: cwo.program_update_date
2130: FROM cst_write_offs cwo,
2131: po_accrual_write_offs_all pawo,
2132: po_lookup_codes plc,
2133: ap_invoice_distributions_all aida,
2134: ap_ae_lines_all aal,
2135: cst_accrual_accounts ca, --BUG#7528609
2136: xla_distribution_links xld