APPS.PAY_US_PPM_HOOK dependencies on PAY_EXTERNAL_ACCOUNTS

Line 119: L_SEGMENT3 PAY_EXTERNAL_ACCOUNTS.SEGMENT3%TYPE;

115: ,p_effective_date in date) is
116:
117: l_is_foreign_trans VARCHAR2(30);
118: transit_code NUMBER;
119: L_SEGMENT3 PAY_EXTERNAL_ACCOUNTS.SEGMENT3%TYPE;
120: L_SEGMENT4 PAY_EXTERNAL_ACCOUNTS.SEGMENT4%TYPE;
121: L_PPM_INFORMATION1 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION1%TYPE;
122: L_PPM_INFORMATION2 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION2%TYPE;
123: L_PPM_INFORMATION3 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION3%TYPE;

Line 120: L_SEGMENT4 PAY_EXTERNAL_ACCOUNTS.SEGMENT4%TYPE;

116:
117: l_is_foreign_trans VARCHAR2(30);
118: transit_code NUMBER;
119: L_SEGMENT3 PAY_EXTERNAL_ACCOUNTS.SEGMENT3%TYPE;
120: L_SEGMENT4 PAY_EXTERNAL_ACCOUNTS.SEGMENT4%TYPE;
121: L_PPM_INFORMATION1 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION1%TYPE;
122: L_PPM_INFORMATION2 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION2%TYPE;
123: L_PPM_INFORMATION3 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION3%TYPE;
124:

Line 127: FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_EXTERNAL_ACCOUNTS EXT

123: L_PPM_INFORMATION3 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION3%TYPE;
124:
125: CURSOR CSR_BANK_SEGMENTS IS
126: SELECT EXT.SEGMENT3, EXT.SEGMENT4
127: FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_EXTERNAL_ACCOUNTS EXT
128: WHERE PPM.PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
129: AND EXT.EXTERNAL_ACCOUNT_ID = PPM.EXTERNAL_ACCOUNT_ID
130: AND P_EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
131: AND PPM.EFFECTIVE_END_DATE;