APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on DUAL

Line 755: FROM DUAL;

751: c.party_site_id = p_install_location AND
752: c.location_id = p_location;
753: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
754: SELECT decode(p_flg,'S','S','E','E','R','R','S')
755: FROM DUAL;
756:
757: --stmathew - Bug 4372869/4222231..start
758: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
759: SELECT SALESREP_ID, NAME

Line 1254: FROM DUAL;

1250: WHERE inventory_item_id = p_inv_item_id;
1251:
1252: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
1253: SELECT decode(p_flg,'S','S','E','E','R','R','S')
1254: FROM DUAL;
1255:
1256: CURSOR tax_exmpt_reason_csr ( p_flg VARCHAR2 ) IS
1257: SELECT decode(p_flg,'E','MANUFACTURER',NULL)
1258: FROM dual;

Line 1258: FROM dual;

1254: FROM DUAL;
1255:
1256: CURSOR tax_exmpt_reason_csr ( p_flg VARCHAR2 ) IS
1257: SELECT decode(p_flg,'E','MANUFACTURER',NULL)
1258: FROM dual;
1259:
1260: l_reason_code VARCHAR2(30);
1261:
1262: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 1862: FROM dual

1858: --gkhuntet - FP Bug 5516814..end
1859: --dkagrawa added union for ppd to to select contract number even if there is no advance receipt for contract
1860: UNION
1861: SELECT cp_cont_number
1862: FROM dual
1863: WHERE p_ppd_flow = 'Y';
1864:
1865: CURSOR l_get_inv_org_yn_csr(cp_org_id IN NUMBER) IS
1866: SELECT lease_inv_org_yn

Line 2237: FROM DUAL;

2233: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2234:
2235: CURSOR seq_csr IS
2236: SELECT AR_INTERFACE_CONTS_S.nextval
2237: FROM DUAL;
2238:
2239: CURSOR err_csr IS
2240: SELECT error_message, invalid_value
2241: FROM ar_trx_errors_gt;