APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1629: FROM pay_external_accounts pea

1625: ,pea.segment4 bank_branch
1626: ,pea.segment1 account_number
1627: ,ppm.percentage percentage
1628: ,pop.currency_code
1629: FROM pay_external_accounts pea
1630: ,pay_pre_payments ppp
1631: ,pay_org_payment_methods_f pop
1632: ,pay_personal_payment_methods_f ppm
1633: WHERE ppp.assignment_action_id = p_curr_pymt_ass_act_id

Line 1676: l_bank_name pay_external_accounts.segment3%TYPE;

1672: l_ovn NUMBER;
1673: l_tax_unit_id NUMBER;
1674: l_procedure VARCHAR2(80);
1675: /*4229709*/
1676: l_bank_name pay_external_accounts.segment3%TYPE;
1677: l_bank_branch pay_external_accounts.segment4%TYPE;
1678: l_bank VARCHAR2(310);
1679: l_account_number pay_external_accounts.segment1%TYPE;
1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;

Line 1677: l_bank_branch pay_external_accounts.segment4%TYPE;

1673: l_tax_unit_id NUMBER;
1674: l_procedure VARCHAR2(80);
1675: /*4229709*/
1676: l_bank_name pay_external_accounts.segment3%TYPE;
1677: l_bank_branch pay_external_accounts.segment4%TYPE;
1678: l_bank VARCHAR2(310);
1679: l_account_number pay_external_accounts.segment1%TYPE;
1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1681: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;

Line 1679: l_account_number pay_external_accounts.segment1%TYPE;

1675: /*4229709*/
1676: l_bank_name pay_external_accounts.segment3%TYPE;
1677: l_bank_branch pay_external_accounts.segment4%TYPE;
1678: l_bank VARCHAR2(310);
1679: l_account_number pay_external_accounts.segment1%TYPE;
1680: l_percentage pay_personal_payment_methods_f.percentage%TYPE;
1681: l_currency_code pay_org_payment_methods_f.currency_code%TYPE;
1682: l_prof_tax_number hr_organization_information.org_information1%TYPE;
1683: /*4229709*/