APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CORRESPONDENCES_ALL

Line 1094: l_correspondence_date ar_correspondences_all.correspondence_date%type;

1090: p_mode IN VARCHAR2 default 'CREATE',
1091: p_errormsg OUT nocopy VARCHAR2,
1092: p_resultout out nocopy VARCHAR2) IS
1093:
1094: l_correspondence_date ar_correspondences_all.correspondence_date%type;
1095: l_dunning_count NUMBER;
1096: BEGIN
1097: IF pg_wf_debug = 'Y'
1098: THEN

Line 1109: FROM ar_correspondences_all

1105: THEN
1106: BEGIN
1107: SELECT max(correspondence_date), count(*)
1108: INTO l_correspondence_date, l_dunning_count
1109: FROM ar_correspondences_all
1110: WHERE correspondence_type = 'DUNNING'
1111: AND customer_id = p_cust_account_id
1112: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
1113: decode(p_org_id,null, org_id, p_org_id), null,

Line 1122: FROM ar_correspondences_all

1118: THEN
1119: BEGIN
1120: SELECT max(correspondence_date), count(*)
1121: INTO l_correspondence_date, l_dunning_count
1122: FROM ar_correspondences_all
1123: WHERE correspondence_type = 'DUNNING'
1124: AND customer_id = p_cust_account_id
1125: AND site_use_id = p_site_use_id
1126: AND correspondence_date >= ADD_MONTHS(sysdate,(-p_period));

Line 1133: FROM ar_correspondences_all

1129: THEN
1130: BEGIN
1131: SELECT max(correspondence_date), count(*)
1132: INTO l_correspondence_date, l_dunning_count
1133: FROM ar_correspondences_all
1134: WHERE correspondence_type = 'DUNNING'
1135: AND customer_id in (
1136: select TO_NUMBER(cust_account_id) -- Fix for Bug 12670874
1137: FROM hz_cust_accounts