DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 150: FROM pay_personal_payment_methods_f pppm,

146: ,segment16 ,segment17 ,segment18 ,segment19
147: ,segment20 ,segment21 ,segment22 ,segment23
148: ,segment24 ,segment25 ,segment26 ,segment27
149: ,segment28 ,segment29 ,segment30 ,org_payment_method_id
150: FROM pay_personal_payment_methods_f pppm,
151: pay_external_accounts pea
152: WHERE --pppm.assignment_id = p_assignment_id
153: pppm.personal_payment_method_id = p_per_pay_method
154: AND pppm.external_account_id = pea.external_account_id

Line 193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;

189: and ppa.effective_date between pp.effective_start_date
190: and pp.effective_end_date;
191:
192:
193: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
194: lv_first_name per_all_people_f.first_name%TYPE;
195: lv_last_name per_all_people_f.last_name%TYPE;
196: lv_middle_names per_all_people_f.middle_names%TYPE;
197: lv_order_name per_all_people_f.order_name%TYPE;