DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_HK_ASG_PAYMENT_RUNS_V

Line 610: FROM pay_hk_asg_payment_runs_v

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

Line 662: l_mail_stop pay_hk_asg_payment_runs_v.MAILSTOP%TYPE;

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