APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on DUAL

Line 919: select decode(X_pay_site_flag,'Y','A','I') into l_party_site_rec.status from dual;

915: CLOSE C_PARTY;
916:
917:
918: l_party_site_rec.party_site_id := l_party_site_id;
919: select decode(X_pay_site_flag,'Y','A','I') into l_party_site_rec.status from dual;
920: --l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
921:
922:
923: OPEN c_obj_version_loc (l_location_id);

Line 1234: FROM dual;

1230: OPEN c_gen_cust_num;
1231: FETCH c_gen_cust_num INTO l_gen_cust_num;
1232: IF (l_gen_cust_num <> 'Y') THEN
1233: SELECT hz_cust_accounts_s.nextval INTO X_Customer_Number
1234: FROM dual;
1235: END IF;
1236: CLOSE c_gen_cust_num;
1237:
1238: l_cust_account_rec.account_number := X_customer_number; /* Please check */