APPS.JMF_GTA_TRX_UTIL dependencies on HZ_PARTIES

Line 1435: l_customer_id hz_parties.party_id%TYPE := p_customer_id;

1431: (p_customer_id IN NUMBER
1432: )
1433: RETURN VARCHAR2
1434: IS
1435: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
1436: l_phone_number hz_contact_points.phone_number%TYPE;
1437:
1438: --Fix bug 5263009, Donghai Wang
1439: --Add the sub query to get party id by customer id

Line 1447: AND hcp.owner_table_name = 'HZ_PARTIES'

1443: hcp.phone_number
1444: FROM
1445: hz_contact_points hcp
1446: WHERE hcp.contact_point_type = 'PHONE'
1447: AND hcp.owner_table_name = 'HZ_PARTIES'
1448: AND hcp.owner_table_id = (SELECT
1449: party_id
1450: FROM
1451: hz_cust_accounts_all

Line 1578: l_customer_name hz_parties.party_name%TYPE;

1574: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1575: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1576: l_proc_level NUMBER := fnd_log.level_procedure;
1577:
1578: l_customer_name hz_parties.party_name%TYPE;
1579: CURSOR c_customer_name IS
1580: SELECT
1581: p.party_name
1582: FROM

Line 1583: hz_parties p

1579: CURSOR c_customer_name IS
1580: SELECT
1581: p.party_name
1582: FROM
1583: hz_parties p
1584: ,hz_cust_accounts a
1585: WHERE a.cust_account_id = p_customer_id
1586: AND p.party_id = a.party_id;
1587:

Line 2007: l_bank_name HZ_PARTIES.party_name%TYPE;

2003: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2004: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2006: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2010:
2011: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

Line 2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

2004: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2006: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2010:
2011: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2012:

Line 2100: HZ_PARTIES HZP,

2096: IBY_FNDCPT_PMT_CHNNLS_VL P,
2097: IBY_FNDCPT_TX_EXTENSIONS X,
2098: IBY_FNDCPT_TX_OPERATIONS OP,
2099: IBY_PMT_INSTR_USES_ALL U,
2100: HZ_PARTIES HZP,
2101: FND_APPLICATION A
2102: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2103: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =
2104: c.instrid(+))

Line 2210: HZ_PARTIES

2206: party_name
2207: INTO
2208: l_bank_name
2209: FROM
2210: HZ_PARTIES
2211: WHERE
2212: party_id = l_bank_id;
2213:
2214: -- get bank branch name

Line 2220: HZ_PARTIES

2216: party_name
2217: INTO
2218: l_bank_branch_name
2219: FROM
2220: HZ_PARTIES
2221: WHERE party_id = l_bank_branch_id;
2222:
2223:
2224: EXCEPTION