DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_PAYMENT_WORKSHEETS

Line 2887: FROM cn_payment_worksheets

2883: ) RETURN VARCHAR2 IS
2884:
2885: CURSOR get_worksheet IS
2886: SELECT 1
2887: FROM cn_payment_worksheets
2888: WHERE payrun_id = p_payrun_id
2889: AND salesrep_id = p_salesrep_id
2890: AND org_id = p_org_id;
2891:

Line 2932: FROM cn_payment_worksheets

2928: ) RETURN VARCHAR2 IS
2929:
2930: CURSOR get_worksheet IS
2931: SELECT worksheet_status
2932: FROM cn_payment_worksheets
2933: WHERE payrun_id = p_payrun_id
2934: AND salesrep_id = p_salesrep_id
2935: AND org_id = p_org_id
2936: AND quota_id iS NULL;