APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on XTR_DEALER_CODES

Line 663: FROM xtr_dealer_codes

659: AND b.balance_date < l_prv_date);
660:
661: CURSOR DEALER_DETAILS IS
662: SELECT dealer_code
663: FROM xtr_dealer_codes
664: WHERE user_id = FND_GLOBAL.USER_ID;
665:
666:
667: l_rounding_type VARCHAR2(1);

Line 676: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

672: l_oldest_date DATE;
673: l_original_amount NUMBER;
674: l_prv_prv_day_count_type VARCHAR2(1);
675:
676: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
677: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
678: --
679: begin
680: -- Calculate Setoff details

Line 677: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

673: l_original_amount NUMBER;
674: l_prv_prv_day_count_type VARCHAR2(1);
675:
676: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
677: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
678: --
679: begin
680: -- Calculate Setoff details
681: OPEN NOTIONAL_ACCT_NO;

Line 1004: FROM xtr_dealer_codes

1000: subs.fund_conc_account_id = l_bank_account_id);
1001:
1002: CURSOR DEALER_DETAILS IS
1003: SELECT dealer_code
1004: FROM xtr_dealer_codes
1005: WHERE user_id = FND_GLOBAL.USER_ID;
1006:
1007: l_rounding_type VARCHAR2(1);
1008: l_day_count_type VARCHAR2(1);

Line 1018: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

1014: l_original_amount NUMBER;
1015: l_prv_prv_day_count_type VARCHAR2(1);
1016: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
1017: l_conc_acct_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
1018: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1019: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1020: --
1021: begin
1022:

Line 1019: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;

1015: l_prv_prv_day_count_type VARCHAR2(1);
1016: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
1017: l_conc_acct_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
1018: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1019: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1020: --
1021: begin
1022:
1023: OPEN DEALER_DETAILS;