APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_HK_ASG_PAYMENT_RUNS_V

Line 611: FROM pay_hk_asg_payment_runs_v

607:
608: CURSOR csr_payment_runs(p_assignment_action_id NUMBER)
609: IS
610: SELECT tax_unit_id,mailstop
611: FROM pay_hk_asg_payment_runs_v
612: WHERE assignment_action_id = p_assignment_action_id;
613:
614:
615: -- Cursor to get the bank name,percentage and currency code using the view

Line 663: l_mail_stop pay_hk_asg_payment_runs_v.MAILSTOP%TYPE;

659: l_bank_account pay_hk_asg_payment_meth_v.BANK_ACCOUNT%TYPE;
660: l_payment_method pay_hk_asg_payment_meth_v.PAYMENT_METHOD%TYPE;
661: l_currency pay_hk_asg_payment_meth_v.CURRENCY%TYPE;
662: l_payment_amount NUMBER;
663: l_mail_stop pay_hk_asg_payment_runs_v.MAILSTOP%TYPE;
664:
665: l_mpf_due_date VARCHAR2(100);
666:
667: