eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIC_LIFECYCLE_EXTRACT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 211: FROM hz_cust_accounts

207: PROCEDURE Insert_New_Cust IS
208:
209: CURSOR party_cur IS
210: SELECT party_id, MIN(NVL(account_established_date,creation_date))
211: FROM hz_cust_accounts
212: GROUP BY party_id
213: HAVING MIN(NVL(account_established_date,creation_date)) >=
214: ADD_MONTHS(g_lc_st_month,g_lc_new_cust_period*-1 +1 );
215: x_party_id hz_cust_accounts.party_id % TYPE;

Line 215: x_party_id hz_cust_accounts.party_id % TYPE;

211: FROM hz_cust_accounts
212: GROUP BY party_id
213: HAVING MIN(NVL(account_established_date,creation_date)) >=
214: ADD_MONTHS(g_lc_st_month,g_lc_new_cust_period*-1 +1 );
215: x_party_id hz_cust_accounts.party_id % TYPE;
216: x_account_established_date hz_cust_accounts.account_established_date % TYPE;
217: BEGIN
218: bic_summary_extract_pkg.debug(' entered Insert_New_Cust + : ');
219: OPEN party_cur;

Line 216: x_account_established_date hz_cust_accounts.account_established_date % TYPE;

212: GROUP BY party_id
213: HAVING MIN(NVL(account_established_date,creation_date)) >=
214: ADD_MONTHS(g_lc_st_month,g_lc_new_cust_period*-1 +1 );
215: x_party_id hz_cust_accounts.party_id % TYPE;
216: x_account_established_date hz_cust_accounts.account_established_date % TYPE;
217: BEGIN
218: bic_summary_extract_pkg.debug(' entered Insert_New_Cust + : ');
219: OPEN party_cur;
220: LOOP