DBA Data[Home] [Help]

APPS.AR_ARXKIR_XMLP_PKG dependencies on AR_CREDIT_HISTORIES

Line 110: AR_CREDIT_HISTORIES CH,

106: ,0))
107: ,0) YEAR_ON_HOLD_Y_COUNT
108: INTO CURRENT_ON_HOLD_Y_COUNT,PRIOR_ON_HOLD_Y_COUNT,YEAR_ON_HOLD_Y_COUNT
109: FROM
110: AR_CREDIT_HISTORIES CH,
111: GL_PERIOD_STATUSES GPS
112: WHERE CH.CREATION_DATE BETWEEN GPS.START_DATE
113: AND GPS.END_DATE
114: AND CH.ON_HOLD = 'Y'

Line 140: AR_CREDIT_HISTORIES CH,

136: ,0))
137: ,0) YEAR_ON_HOLD_N_COUNT
138: INTO CURRENT_ON_HOLD_N_COUNT,PRIOR_ON_HOLD_N_COUNT,YEAR_ON_HOLD_N_COUNT
139: FROM
140: AR_CREDIT_HISTORIES CH,
141: GL_PERIOD_STATUSES GPS
142: WHERE CH.CREATION_DATE BETWEEN GPS.START_DATE
143: AND GPS.END_DATE
144: AND CH.ON_HOLD = 'N'