APPS.PAY_NO_PAYPROC dependencies on PAY_EXTERNAL_ACCOUNTS

Line 499: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;

495: l_text3 varchar2(100);
496: l_text4 varchar2(100);
497:
498:
499: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;
500:
501: l_payee_name varchar2(100);
502: l_amount number(15);
503:

Line 506: from pay_external_accounts pea,

502: l_amount number(15);
503:
504: cursor get_per_org_account_no is
505: select pea.segment6
506: from pay_external_accounts pea,
507: pay_personal_payment_methods_f ppp
508: where
509: ppp.personal_payment_method_id=p_per_pay_method_id
510: and ppp.external_account_id=pea.external_account_id

Line 736: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;

732:
733: l_text1 varchar2(300);
734:
735:
736: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;
737:
738: l_per_account_num_t varchar2(17);
739: l_text_account_no varchar2(30);
740:

Line 746: from pay_external_accounts pea,

742: l_amount varchar2(25);
743:
744: cursor get_per_org_account_no is
745: select pea.segment6
746: from pay_external_accounts pea,
747: pay_personal_payment_methods_f ppp
748: where
749: ppp.personal_payment_method_id=p_per_pay_method_id
750: and ppp.external_account_id=pea.external_account_id