DBA Data[Home] [Help]

APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on HZ_PARTIES

Line 652: hz_parties hp,

648: (SELECT distinct person_id ,national_identifier
649: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf,
650: je_it_setup_doc_seqs_all ds,
651: jg_zz_vat_rep_entities repent,
652: hz_parties hp,
653: ap_invoice_distributions_all itemdist,
654: ap_invoice_lines_all itemline
655:
656: WHERE repent.vat_reporting_entity_id = g_vat_reporting_entity_id

Line 1114: hz_parties hp,

1110: ra_cust_trx_line_gl_dist_all rctd,
1111: ra_cust_trx_types_all rctt,
1112: ar_receipt_methods arm,
1113: hz_cust_accounts hca,
1114: hz_parties hp,
1115: hz_cust_site_uses_all hcsu,
1116: hz_cust_acct_sites_all hcas,
1117: hz_party_sites hps,
1118: hz_locations hl,

Line 1248: hz_parties hp,

1244: ra_cust_trx_line_gl_dist_all rctd,
1245: ra_cust_trx_types_all rctt,
1246: ar_receipt_methods arm,
1247: hz_cust_accounts hca,
1248: hz_parties hp,
1249: hz_cust_site_uses_all hcsu,
1250: hz_cust_acct_sites_all hcas,
1251: hz_party_sites hps,
1252: hz_locations hl,