APPS.PAY_NO_PAYPROC dependencies on PAY_EXTERNAL_ACCOUNTS

Line 477: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;

473: l_text3 varchar2(100);
474: l_text4 varchar2(100);
475:
476:
477: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;
478:
479: l_payee_name varchar2(100);
480: l_amount number(15);
481:

Line 484: from pay_external_accounts pea,

480: l_amount number(15);
481:
482: cursor get_per_org_account_no is
483: select pea.segment6
484: from pay_external_accounts pea,
485: pay_personal_payment_methods_f ppp
486: where
487: ppp.personal_payment_method_id=p_per_pay_method_id
488: and ppp.external_account_id=pea.external_account_id;

Line 713: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;

709:
710: l_text1 varchar2(300);
711:
712:
713: l_per_account_num PAY_EXTERNAL_ACCOUNTS.SEGMENT6%TYPE;
714:
715: l_per_account_num_t varchar2(17);
716: l_text_account_no varchar2(30);
717:

Line 723: from pay_external_accounts pea,

719: l_amount varchar2(25);
720:
721: cursor get_per_org_account_no is
722: select pea.segment6
723: from pay_external_accounts pea,
724: pay_personal_payment_methods_f ppp
725: where
726: ppp.personal_payment_method_id=p_per_pay_method_id
727: and ppp.external_account_id=pea.external_account_id;