DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_PAYMENT_WORKSHEETS

Line 2909: FROM cn_payment_worksheets

2905: ) RETURN VARCHAR2 IS
2906:
2907: CURSOR get_worksheet IS
2908: SELECT 1
2909: FROM cn_payment_worksheets
2910: WHERE payrun_id = p_payrun_id
2911: AND salesrep_id = p_salesrep_id
2912: AND org_id = p_org_id;
2913:

Line 2954: FROM cn_payment_worksheets

2950: ) RETURN VARCHAR2 IS
2951:
2952: CURSOR get_worksheet IS
2953: SELECT worksheet_status
2954: FROM cn_payment_worksheets
2955: WHERE payrun_id = p_payrun_id
2956: AND salesrep_id = p_salesrep_id
2957: AND org_id = p_org_id
2958: AND quota_id iS NULL;

Line 3198: FROM cn_payment_worksheets cnw

3194:
3195: CURSOR C_GET_SALESREP_ID
3196: IS
3197: SELECT salesrep_id
3198: FROM cn_payment_worksheets cnw
3199: WHERE cnw.payrun_id = p_payrun_id
3200: AND cnw.org_id = p_ORG_ID
3201: AND cnw.quota_id IS NULL ;
3202: