APPS.PAY_US_PPM_HOOK dependencies on PAY_PERSONAL_PAYMENT_METHODS

Line 121: L_PPM_INFORMATION1 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION1%TYPE;

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:
125: CURSOR CSR_BANK_SEGMENTS IS

Line 122: L_PPM_INFORMATION2 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION2%TYPE;

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:
125: CURSOR CSR_BANK_SEGMENTS IS
126: SELECT EXT.SEGMENT3, EXT.SEGMENT4

Line 123: L_PPM_INFORMATION3 PAY_PERSONAL_PAYMENT_METHODS_F.PPM_INFORMATION3%TYPE;

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:
125: CURSOR CSR_BANK_SEGMENTS IS
126: SELECT EXT.SEGMENT3, EXT.SEGMENT4
127: FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_EXTERNAL_ACCOUNTS EXT

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;

Line 137: FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM

133: CURSOR CSR_PPM_INFORMATION IS
134: SELECT PPM.PPM_INFORMATION1,
135: PPM.PPM_INFORMATION2,
136: PPM.PPM_INFORMATION3
137: FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM
138: WHERE PPM.PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
139: AND P_EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
140: AND PPM.EFFECTIVE_END_DATE;
141:

Line 146: from pay_org_payment_methods popm, pay_Personal_payment_methods pppm

142: begin
143:
144: select popm.PMETH_INFORMATION9
145: INTO l_is_foreign_trans
146: from pay_org_payment_methods popm, pay_Personal_payment_methods pppm
147: where popm.ORG_PAYMENT_METHOD_ID = pppm.ORG_PAYMENT_METHOD_ID
148: and pppm.PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
149: AND p_effective_date BETWEEN popm.effective_start_date
150: AND popm.effective_end_date;