DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 146: FROM pay_personal_payment_methods_f pppm,

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

Line 189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;

185: and ppa.effective_date between pp.effective_start_date
186: and pp.effective_end_date;
187:
188:
189: l_org_payment_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
190: lv_first_name per_all_people_f.first_name%TYPE;
191: lv_last_name per_all_people_f.last_name%TYPE;
192: lv_middle_names per_all_people_f.middle_names%TYPE;
193: lv_order_name per_all_people_f.order_name%TYPE;