APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on DUAL

Line 513: FROM DUAL;

509: c.party_site_id = p_install_location AND
510: c.location_id = p_location;
511: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
512: SELECT decode(p_flg,'S','S','E','E','R','R','S')
513: FROM DUAL;
514:
515: --stmathew - Bug 4372869/4222231..start
516: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
517: SELECT SALESREP_ID, NAME

Line 1046: FROM DUAL;

1042: WHERE inventory_item_id = p_inv_item_id;
1043:
1044: CURSOR tax_exmpt_csr ( p_flg VARCHAR2 ) IS
1045: SELECT decode(p_flg,'S','S','E','E','R','R','S')
1046: FROM DUAL;
1047:
1048: CURSOR tax_exmpt_reason_csr ( p_flg VARCHAR2 ) IS
1049: SELECT decode(p_flg,'E','MANUFACTURER',NULL)
1050: FROM dual;

Line 1050: FROM dual;

1046: FROM DUAL;
1047:
1048: CURSOR tax_exmpt_reason_csr ( p_flg VARCHAR2 ) IS
1049: SELECT decode(p_flg,'E','MANUFACTURER',NULL)
1050: FROM dual;
1051:
1052: l_reason_code VARCHAR2(30);
1053:
1054: --start: 02-APR-07 cklee R12 Billing enhancement project |

Line 1654: FROM dual

1650: --gkhuntet - FP Bug 5516814..end
1651: --dkagrawa added union for ppd to to select contract number even if there is no advance receipt for contract
1652: UNION
1653: SELECT cp_cont_number
1654: FROM dual
1655: WHERE p_ppd_flow = 'Y';
1656:
1657: CURSOR l_get_inv_org_yn_csr(cp_org_id IN NUMBER) IS
1658: SELECT lease_inv_org_yn

Line 2029: FROM DUAL;

2025: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2026:
2027: CURSOR seq_csr IS
2028: SELECT AR_INTERFACE_CONTS_S.nextval
2029: FROM DUAL;
2030:
2031: CURSOR err_csr IS
2032: SELECT error_message, invalid_value
2033: FROM ar_trx_errors_gt;