APPS.PAY_FI_ARCHIVE_MTRA dependencies on PAY_EXTERNAL_ACCOUNTS

Line 195: l_tax_office_ba pay_external_accounts.segment3%TYPE ;

191: l_y_number hr_organization_information.org_information1%TYPE ;
192: l_contact_person hr_organization_information.org_information1%TYPE ;
193: l_phone hr_organization_information.org_information1%TYPE ;
194: l_fax hr_organization_information.org_information1%TYPE ;
195: l_tax_office_ba pay_external_accounts.segment3%TYPE ;
196: l_tax_office_pay_meth_id hr_organization_information.org_information2%TYPE ;
197: l_tax_office_name hr_organization_units.name%TYPE ;
198: l_employer_ba pay_external_accounts.segment3%TYPE ;
199: l_employer_pay_meth_id hr_organization_information.org_information1%TYPE ;

Line 198: l_employer_ba pay_external_accounts.segment3%TYPE ;

194: l_fax hr_organization_information.org_information1%TYPE ;
195: l_tax_office_ba pay_external_accounts.segment3%TYPE ;
196: l_tax_office_pay_meth_id hr_organization_information.org_information2%TYPE ;
197: l_tax_office_name hr_organization_units.name%TYPE ;
198: l_employer_ba pay_external_accounts.segment3%TYPE ;
199: l_employer_pay_meth_id hr_organization_information.org_information1%TYPE ;
200: l_tax_office_id hr_organization_information.organization_id%TYPE ;
201: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
202: l_counter number := 0;

Line 359: FROM pay_org_payment_methods_f a , pay_external_accounts b

355:
356: Cursor csr_account_number ( csr_v_payment_method_id pay_org_payment_methods_f.org_payment_method_id%TYPE)
357: IS
358: SELECT b.segment3
359: FROM pay_org_payment_methods_f a , pay_external_accounts b
360: WHERE a.org_payment_method_id = csr_v_payment_method_id
361: AND a.external_account_id = b.external_account_id
362: AND a.business_group_id=l_business_group_id
363: AND a.pmeth_information_category ='FI Third Party Payment';