APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on GL_JE_HEADERS

Line 636: Gl_Je_Headers Jeh

632: Xla_Transaction_Entities Ent,
633: Xla_Ae_Headers Aeh,
634: Xla_Ae_Lines Ael,
635: Gl_Import_References Gir,
636: Gl_Je_Headers Jeh
637: WHERE Rct.Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
638: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
639: AND Rctlgd.ACCOUNT_CLASS = 'REC'
640: AND Rctlgd.LATEST_REC_FLAG = 'Y'

Line 675: Gl_Je_Headers Jeh,

671: AR_RECEIVABLE_APPLICATIONS_ALL App,
672: Xla_Transaction_Entities Ent,
673: Xla_Ae_Headers Aeh,
674: Xla_Ae_Lines Ael,
675: Gl_Je_Headers Jeh,
676: Gl_Import_References Gir
677: WHERE Acr.Cash_Receipt_Id = App.Cash_Receipt_Id
678: AND App.Applied_Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
679: --SLA condition

Line 703: Gl_Je_Headers Jeh

699: Ael.Entered_Dr Entered_Dr,
700: Ael.Entered_Cr Entered_Cr
701: FROM Xla_Ae_Lines Ael,
702: Gl_Import_References Gir,
703: Gl_Je_Headers Jeh
704: WHERE Ael.Accounting_Class_Code = 'RECEIVABLE'
705: AND Ael.Application_Id = 222
706: AND (Ael.Ae_Header_Id,Ael.Ae_Line_Num) IN
707: (SELECT Xdl.Ae_Header_Id,

Line 753: Gl_Je_Headers Jeh

749: Xla_Transaction_Entities Ent,
750: Xla_Ae_Headers Aeh,
751: Xla_Ae_Lines Ael,
752: Gl_Import_References Gir,
753: Gl_Je_Headers Jeh
754: WHERE Rct.Previous_Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
755: AND Rct.CUSTOMER_TRX_ID = Rctlgd.CUSTOMER_TRX_ID
756: AND Rctlgd.ACCOUNT_CLASS = 'REC'
757: AND Rctlgd.LATEST_REC_FLAG = 'Y'

Line 787: Gl_Je_Headers Jeh

783: Xla_Transaction_Entities Ent,
784: Xla_Ae_Headers Aeh,
785: Xla_Ae_Lines Ael,
786: Gl_Import_References Gir,
787: Gl_Je_Headers Jeh
788: WHERE Adj.Customer_Trx_Id = pn_customer_trx_id -- variable: pn_customer_trx_id
789: --SLA condition
790: AND Ent.Application_Id = 222
791: AND Adj.Adjustment_Id = Ent.Source_Id_Int_1

Line 1460: FROM GL_JE_HEADERS jeh,

1456: SELECT DECODE(COUNT(*)
1457: ,0
1458: ,'Y'
1459: ,'N') no_trans_flag
1460: FROM GL_JE_HEADERS jeh,
1461: GL_JE_LINES jel,
1462: GL_IMPORT_REFERENCES gir,
1463: XLA_AE_LINES ael,
1464: XLA_AE_HEADERS aeh,

Line 1697: FROM GL_JE_HEADERS jeh,

1693: part.party_number Customer_Number,
1694: jcc.Account_Segment Account_Number,
1695: pv_accounting_year Accounting_Year,
1696: jeh.default_effective_date
1697: FROM GL_JE_HEADERS jeh,
1698: GL_JE_LINES jel,
1699: GL_IMPORT_REFERENCES gir,
1700: XLA_AE_LINES ael,
1701: XLA_AE_HEADERS aeh,

Line 1928: Gl_Je_Headers Jeh,

1924: Xla_Transaction_Entities Ent,
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Gl_Import_References Gir,
1928: Gl_Je_Headers Jeh,
1929: Gl_Ledgers Gl,
1930: Gl_Periods Gp,
1931: fnd_currencies_vl Fcv
1932: WHERE Rct.customer_trx_id = ln_customer_trx_id --variable: ln_customer_trx_id

Line 1989: Gl_Je_Headers Jeh,

1985: AR_RECEIVABLE_APPLICATIONS_ALL App,
1986: Xla_Transaction_Entities Ent,
1987: Xla_Ae_Headers Aeh,
1988: Xla_Ae_Lines Ael,
1989: Gl_Je_Headers Jeh,
1990: Gl_Import_References Gir,
1991: Gl_Ledgers Gl,
1992: Gl_Periods Gp,
1993: fnd_currencies_vl Fcv

Line 2119: Gl_Je_Headers Jeh,

2115: Xla_Transaction_Entities Ent,
2116: Xla_Ae_Headers Aeh,
2117: Xla_Ae_Lines Ael,
2118: Gl_Import_References Gir,
2119: Gl_Je_Headers Jeh,
2120: Gl_Ledgers Gl,
2121: Gl_Periods Gp,
2122: fnd_currencies_vl fcv
2123: WHERE Rct.Previous_Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id

Line 2219: Gl_Je_Headers Jeh,

2215: Xla_Transaction_Entities Ent,
2216: Xla_Ae_Headers Aeh,
2217: Xla_Ae_Lines Ael,
2218: Gl_Import_References Gir,
2219: Gl_Je_Headers Jeh,
2220: Gl_Ledgers Gl,
2221: Gl_Periods Gp
2222: WHERE Adj.Customer_Trx_Id = ln_customer_trx_id -- variable: ln_customer_trx_id
2223: --SLA condition