APPS.AR_ARXCCS_XMLP_PKG dependencies on AR_STATEMENT_CYCLES

Line 2125: SELECT AR_STATEMENT_CYCLES.NAME,

2121: l_last_st_date VARCHAR2 (11);
2122: l_last_st_days_since VARCHAR2 (100);
2123:
2124: CURSOR C_STATEMENT IS
2125: SELECT AR_STATEMENT_CYCLES.NAME,
2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES

Line 2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,

2124: CURSOR C_STATEMENT IS
2125: SELECT AR_STATEMENT_CYCLES.NAME,
2126: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =

Line 2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID

2127: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID

Line 2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =

2128: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2129: AR_STATEMENT_CYCLE_DATES
2130: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2131: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2132: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2133: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2134: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2135: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2136: AND HZ_CUSTOMER_PROFILES.site_use_id = site_use_id

Line 2141: SELECT AR_STATEMENT_CYCLES.NAME,

2137: ORDER BY AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE DESC,
2138: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_DATE_ID DESC ;
2139:
2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES

Line 2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,

2140: CURSOR C_STATEMENT_DEFAULT IS
2141: SELECT AR_STATEMENT_CYCLES.NAME,
2142: AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE,
2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =

Line 2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID

2143: TRUNC(TRUNC(SYSDATE) - AR_STATEMENT_CYCLE_DATES.STATEMENT_DATE)
2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID

Line 2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =

2144: FROM HZ_CUSTOMER_PROFILES, AR_STATEMENT_CYCLES,
2145: AR_STATEMENT_CYCLE_DATES
2146: WHERE HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID =
2147: AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID
2148: AND AR_STATEMENT_CYCLES.STATEMENT_CYCLE_ID =
2149: AR_STATEMENT_CYCLE_DATES.STATEMENT_CYCLE_ID
2150: AND AR_STATEMENT_CYCLE_DATES.PRINTED = 'Y'
2151: AND HZ_CUSTOMER_PROFILES.CUST_ACCOUNT_ID = CUSTOMER_ID
2152: AND HZ_CUSTOMER_PROFILES.site_use_id is null