APPS.FV_SF1081_TRANSACTION dependencies on HZ_PARTIES

Line 410: vc_customer_name hz_parties.party_name%TYPE;

406: l_ledger_name varchar2(200);
407: --
408: vc_trx_number ra_customer_trx.trx_number%TYPE;
409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
410: vc_customer_name hz_parties.party_name%TYPE;
411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
413: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;
414: vc_address1 hz_locations.address1%TYPE;

Line 458: HZ_PARTIES HZP

454: HZ_LOCATIONS HZL,
455: HZ_CUST_ACCT_SITES HZCAS,
456: HZ_CUST_ACCOUNTS HZCA,
457: HZ_PARTY_SITES HZPS,
458: HZ_PARTIES HZP
459: WHERE
460: RCT.CUSTOMER_TRX_ID = RTL.CUSTOMER_TRX_ID
461: AND RTL.CUSTOMER_TRX_LINE_ID = RLD.CUSTOMER_TRX_LINE_ID
462: AND RCT.COMPLETE_FLAG = 'Y'

Line 553: hz_parties hzp,

549: hz_cust_acct_sites hzcas,
550: hz_party_sites hzps ,
551: HZ_CUST_SITE_USEs hzcsu,
552: hz_cust_accounts hzca,
553: hz_parties hzp,
554: ra_customer_trx rct,
555: ra_customer_trx_lines rtl,
556: ra_cust_trx_line_gl_dist rld,
557: ce_bank_accounts cba,