DBA Data[Home] [Help]

APPS.CN_PMT_TRANS_PVT dependencies on CN_SALESREPS

Line 1687: cn_payment_worksheets wk, cn_salesreps srp

1683: CURSOR get_paysheet_details IS
1684: SELECT
1685: payment_worksheet_id,object_version_number, name
1686: FROM
1687: cn_payment_worksheets wk, cn_salesreps srp
1688: WHERE
1689: quota_id is null
1690: AND wk.payrun_id = p_payrun_id
1691: AND wk.salesrep_id = p_salesrep_id

Line 1695: l_srp_name cn_salesreps.name%type ;

1691: AND wk.salesrep_id = p_salesrep_id
1692: AND wk.salesrep_id = srp.salesrep_id ;
1693:
1694: l_new_status cn_payment_worksheets.worksheet_status%type ;
1695: l_srp_name cn_salesreps.name%type ;
1696:
1697: BEGIN
1698: SAVEPOINT hold_multiple_trans_conc;
1699: retcode := 0;