APPS.IGIRCBJP dependencies on AR_LOOKUPS

Line 47: CatMeaning ar_lookups.meaning%TYPE,

43: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
44: GLDate DATE, -- the gl date of the application
45: TrxDate DATE, -- the apply date of the application
46: AppType ar_receivable_applications.application_type%TYPE,
47: CatMeaning ar_lookups.meaning%TYPE,
48: PostingControlId ar_receivable_applications.posting_control_id%TYPE
49: );
50: --
51: -- holds ApplicationAmount values

Line 1188: ar_lookups l_cat,

1184: igi_ar_rec_applications igira,
1185: ar_cash_receipts cr,
1186: hz_parties, -- Bug 3902175
1187: hz_cust_accounts, -- Bug 3902175
1188: ar_lookups l_cat,
1189: xla_ae_headers xah
1190: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1191: AND p_Report.GLDateTo
1192: AND igira.receivable_application_id = ra.receivable_application_id

Line 1479: ar_lookups l,

1475: ra_customer_trx ct,
1476: ar_cash_receipts cr,
1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1480: ar_lookups l_cat,
1481: hz_parties, -- Bug 3902175
1482: hz_cust_accounts, -- Bug 3902175
1483: xla_ae_headers xah

Line 1480: ar_lookups l_cat,

1476: ar_cash_receipts cr,
1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1480: ar_lookups l_cat,
1481: hz_parties, -- Bug 3902175
1482: hz_cust_accounts, -- Bug 3902175
1483: xla_ae_headers xah
1484: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom

Line 1710: ar_lookups l_cat,

1706: igi_ar_cash_receipt_hist igicrh,
1707: ar_cash_receipts cr,
1708: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
1709: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
1710: ar_lookups l_cat,
1711: ar_distributions d,
1712: xla_ae_headers xah
1713: WHERE crh.gl_date BETWEEN p_Report.GlDateFrom
1714: AND p_Report.GLDateTo

Line 1929: ar_lookups l_cat,

1925: l_cat.meaning CatMeaning
1926: FROM ar_misc_cash_distributions mcd,
1927: igi_ar_misc_cash_dists igimcd,
1928: ar_cash_receipts cr,
1929: ar_lookups l_cat,
1930: xla_ae_headers xah
1931: WHERE mcd.gl_date BETWEEN p_Report.GlDateFrom AND p_Report.GLDateTo
1932: AND cr.cash_receipt_id = mcd.cash_receipt_id
1933: AND mcd.misc_cash_distribution_id = igimcd.misc_cash_distribution_id