APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on HZ_PARTIES

Line 256: hz_parties hzp1,

252: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
253: AR_PAYMENT_SCHEDULES_ALL aps,
254: --RA_CUSTOMERS rc, Bug#4476059 Quick Change
255: hz_cust_accounts hzca1,
256: hz_parties hzp1,
257: FV_RECEIVABLE_TYPES_ALL frt,
258: FV_REC_CUST_TRX_TYPES_ALL fctt,
259: GL_CODE_COMBINATIONS glc
260: --FV_INVOICE_STATUSES_ALL fvis

Line 300: hz_parties hzp2

296: FROM RA_CUSTOMER_TRX_ALL rct2,
297: AR_PAYMENT_SCHEDULES_ALL aps2,
298: --RA_CUSTOMERS rc2 Bug#4476059 Quick Change
299: hz_cust_accounts hzca2,
300: hz_parties hzp2
301: -- FV_INVOICE_STATUSES_ALL fvis
302: where aps2.class in ('DM','CM')
303: and hzca2.cust_account_id = rct2.bill_to_customer_id
304: and hzca2.party_id = hzp2.party_id

Line 316: hz_parties hzp3,

312: from RA_CUSTOMER_TRX_ALL rct3,
313: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
314: --RA_CUSTOMERS rc3,-- Bug#4476059 Quick Change
315: hz_cust_accounts hzca3,
316: hz_parties hzp3,
317: AR_PAYMENT_SCHEDULES_ALL aps3,
318: FV_RECEIVABLE_TYPES_ALL frt3,
319: FV_REC_CUST_TRX_TYPES_ALL fctt3,
320: -- FV_FUND_PARAMETERS fp3, -- Bug 4655467

Line 1018: hz_parties hzp1,

1014: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
1015: AR_PAYMENT_SCHEDULES_ALL aps,
1016: --RA_CUSTOMERS rc, --Bug#4476059 Quick Change
1017: hz_cust_accounts hzca1,
1018: hz_parties hzp1,
1019: FV_RECEIVABLE_TYPES_ALL frt,
1020: FV_REC_CUST_TRX_TYPES_ALL fctt,
1021: -- FV_FUND_PARAMETERS fp, -- Bug 4655467
1022: GL_CODE_COMBINATIONS glc

Line 1057: hz_parties hzp2

1053: from RA_CUSTOMER_TRX_ALL rct2,
1054: ar_payment_schedules_all aps2,
1055: --ra_customers rc2 --Bug#4476059 Quick Change
1056: hz_cust_accounts hzca2,
1057: hz_parties hzp2
1058: where aps2.class in ('DM','CM')
1059: and hzca2.cust_account_id = rct2.bill_to_customer_id
1060: AND hzca2.party_id = hzp2.party_id
1061: and rct2.customer_trx_id = aps2.customer_trx_id

Line 1072: hz_parties hzp3,

1068: from RA_CUSTOMER_TRX_ALL rct3,
1069: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
1070: --RA_CUSTOMERS rc3, --Bug#4476059 Quick Change
1071: hz_cust_accounts hzca3,
1072: hz_parties hzp3,
1073: AR_PAYMENT_SCHEDULES_ALL aps3,
1074: FV_RECEIVABLE_TYPES_ALL frt3,
1075: FV_REC_CUST_TRX_TYPES_ALL fctt3,
1076: -- FV_FUND_PARAMETERS fp3, -- Bug 4655467

Line 1120: hz_parties hzp1,

1116: FROM ar_adjustments_all ara,
1117: ra_customer_trx_all rct,
1118: --ra_customers rc, --Bug#4476059 Quick Change
1119: hz_cust_accounts hzca1,
1120: hz_parties hzp1,
1121: ra_cust_trx_types_all rctt,
1122: fv_system_parameters fvs
1123: WHERE rct.customer_trx_id = ara.customer_trx_id
1124: AND hzca1.cust_account_id = rct.bill_to_customer_id

Line 1151: hz_parties hzp1,

1147: from ar_receivable_applications_all ara,
1148: ar_cash_receipts_all acr,
1149: --ra_customers rc, ----Bug#4476059 Quick Change
1150: hz_cust_accounts hzca1,
1151: hz_parties hzp1,
1152: ra_customer_trx_all rct
1153: where ara.cash_receipt_id = acr.cash_receipt_id
1154: and ara.status = 'APP'
1155: and ara.apply_date between vl_fy_begin_date and vg_end_date+1