[Home] [Help]
531: /* modified for tca uptake */
532: /* fixed bug 1544201: removed customer_prospect_code */
533: SELECT c.cust_account_id
534: INTO l_selected_id
535: FROM hz_cust_accounts c,
536: hz_customer_profiles cp,
537: hz_parties party
538: WHERE c.cust_account_id = cp.cust_account_id (+) and
539: cp.site_use_id is null and
546: /* modified for tca uptake */
547: /* fixed bug 1544201: removed customer_prospect_code */
548: SELECT cust_acct.cust_account_id
549: INTO l_selected_id
550: FROM hz_cust_accounts cust_acct,
551: hz_customer_profiles cp,
552: hz_parties party
553: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
554: and cust_acct.party_id = party.party_id(+)
740: END Add_Site_Use_To_Cache;
741:
742: /* modified for tca uptake */
743: FUNCTION Find_Site_Use_In_Cache(
744: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
745: p_location IN hz_cust_site_uses.site_use_id%TYPE,
746: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
747: p_index OUT NOCOPY BINARY_INTEGER
748: ) RETURN hz_cust_site_uses.site_use_id%TYPE IS
1757: PROCEDURE Default_cash_ids(
1758: p_usr_currency_code IN fnd_currencies_vl.name%TYPE,
1759: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1760: p_customer_name IN hz_parties.party_name%TYPE,
1761: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
2365: INTO l_grace_days
2366: FROM
2367: hz_customer_profiles cust,
2368: hz_customer_profiles site,
2369: hz_cust_accounts c
2370: WHERE
2371: c.cust_account_id = p_customer_id
2372: AND cust.cust_account_id = c.cust_account_id
2373: AND cust.site_use_id IS NULL
3732: , ra_cust_trx_types ctt
3733: , hz_cust_site_uses su
3734: , ra_batch_sources bs
3735: , ar_lookups lu
3736: , hz_cust_accounts cust
3737: , ra_terms t
3738: , ar_payment_schedules ps
3739: , ar_cons_inv ci
3740: WHERE
3829: , ra_cust_trx_types ctt
3830: , hz_cust_site_uses su
3831: , ra_batch_sources bs
3832: , ar_lookups lu
3833: , hz_cust_accounts cst
3834: , ra_terms t
3835: , ar_payment_schedules ps
3836: , ar_cons_inv ci
3837: WHERE
3864: FROM dual
3865: UNION
3866: SELECT rel.related_cust_account_id
3867: FROM ar_paying_relationships_v rel,
3868: hz_cust_accounts acc
3869: WHERE rel.party_id = acc.party_id
3870: AND acc.cust_account_id = p_cr_customer_id
3871: AND p_cr_date BETWEEN effective_start_date
3872: AND effective_end_date
4078: WHERE ot.customer_id = p_cr_customer_id
4079: UNION ALL
4080: SELECT /*+ no_unnest */ 'x'
4081: FROM ar_paying_relationships_v rel,
4082: hz_cust_accounts acc
4083: WHERE rel.party_id = acc.party_id
4084: AND acc.cust_account_id = p_cr_customer_id
4085: AND p_cr_date BETWEEN effective_start_date
4086: AND effective_end_date
6882: l_sel_stmt := '
6883: SELECT ps.customer_id,
6884: ps.customer_site_use_id
6885: FROM hz_cust_site_uses su,
6886: hz_cust_accounts cust_acct,
6887: ra_cust_trx_types ctt,
6888: ar_payment_schedules ps
6889: WHERE su.site_use_id = ps.customer_site_use_id
6890: and cust_acct.cust_account_id = ps.customer_id
8224: IS
8225: l_trxn_attributes_rec iby_disbursement_comp_pub.trxn_attributes_rec_type;
8226: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
8227: l_org_id ar_cash_receipts.org_id%TYPE;
8228: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
8229: l_site_use_id hz_cust_site_uses.site_use_id%TYPE;
8230: l_party_id hz_parties.party_id%TYPE;
8231: l_party_site_id hz_parties.party_id%TYPE;
8232: l_pmt_attr_rec iby_disbursement_comp_pub.default_pmt_attrs_rec_type;
8281: ,p.party_number
8282: INTO p_party_id
8283: ,x_party_name
8284: ,x_party_number
8285: FROM hz_cust_accounts ca
8286: ,hz_parties p
8287: WHERE p.party_id = ca.party_id
8288: AND ca.cust_account_id = l_cust_acct_id;
8289: EXCEPTION