APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CORRESPONDENCES_ALL

Line 1035: l_correspondence_date ar_correspondences_all.correspondence_date%type;

1031: p_mode IN VARCHAR2 default 'CREATE',
1032: p_errormsg OUT nocopy VARCHAR2,
1033: p_resultout out nocopy VARCHAR2) IS
1034:
1035: l_correspondence_date ar_correspondences_all.correspondence_date%type;
1036: l_dunning_count NUMBER;
1037: BEGIN
1038: IF pg_wf_debug = 'Y'
1039: THEN

Line 1050: FROM ar_correspondences_all

1046: THEN
1047: BEGIN
1048: SELECT max(correspondence_date), count(*)
1049: INTO l_correspondence_date, l_dunning_count
1050: FROM ar_correspondences_all
1051: WHERE correspondence_type = 'DUNNING'
1052: AND customer_id = p_cust_account_id
1053: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',
1054: decode(p_org_id,null, org_id, p_org_id), null,

Line 1063: FROM ar_correspondences_all

1059: THEN
1060: BEGIN
1061: SELECT max(correspondence_date), count(*)
1062: INTO l_correspondence_date, l_dunning_count
1063: FROM ar_correspondences_all
1064: WHERE correspondence_type = 'DUNNING'
1065: AND customer_id = p_cust_account_id
1066: AND site_use_id = p_site_use_id
1067: AND correspondence_date >= ADD_MONTHS(sysdate,(-p_period));

Line 1074: FROM ar_correspondences_all

1070: THEN
1071: BEGIN
1072: SELECT max(correspondence_date), count(*)
1073: INTO l_correspondence_date, l_dunning_count
1074: FROM ar_correspondences_all
1075: WHERE correspondence_type = 'DUNNING'
1076: AND customer_id in (
1077: select cust_account_id
1078: FROM hz_cust_accounts