APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_NA_CUSTOMERS_TEMP

Line 21: FROM ozf_na_customers_temp

17: WHERE cust_account_id = p_sold_to_org_id;
18:
19: CURSOR c_customer_qualified(p_party_id NUMBER) IS
20: SELECT 'Y'
21: FROM ozf_na_customers_temp
22: WHERE (
23: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
24: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
25: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 32: FROM ozf_na_customers_temp

28: AND ROWNUM = 1;
29:
30: CURSOR c_cust_acct_qualified(p_party_id NUMBER) IS
31: SELECT 'Y'
32: FROM ozf_na_customers_temp
33: WHERE (
34: (cust_account_id = p_sold_to_org_id) OR
35: (party_id = p_party_id AND site_use_code IS NULL) OR
36: (party_id = -1)

Line 417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');

413: x_return_status := FND_API.g_ret_sts_success;
414:
415: -- denorm parties
416: FND_DSQL.init;
417: FND_DSQL.add_text('INSERT INTO ozf_na_customers_temp(');
418: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
419: FND_DSQL.add_text('last_update_login,confidential_flag,');
420: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
421: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,marketing_medium_id,start_date,end_date,');

Line 1816: DELETE FROM ozf_na_customers_temp;

1812: l_batch_mode := l_orig_batch_mode;
1813: l_offer_org_id := l_net_accrual_offers.orig_org_id;
1814: END IF;
1815:
1816: DELETE FROM ozf_na_customers_temp;
1817: DELETE FROM ozf_na_products_temp;
1818:
1819: ----------------- Denrom Customers ------------------
1820: IF l_net_accrual_offers.custom_setup_id = 105

Line 1854: -- For all other Offers, populate the ozf_na_customers_temp denom table

1850: END IF;
1851: --
1852: ELSE
1853: --
1854: -- For all other Offers, populate the ozf_na_customers_temp denom table
1855: --
1856:
1857: ozf_utility_pvt.write_conc_log('Populate_Customers (+)');
1858:

Line 3488: DELETE FROM ozf_na_customers_temp;

3484: END IF; -- End IDSM lines
3485:
3486: <>
3487:
3488: DELETE FROM ozf_na_customers_temp;
3489: DELETE FROM ozf_na_products_temp;
3490:
3491: END LOOP;
3492: