[Home] [Help]
32: l_old_record get_old_record%ROWTYPE;
33:
34: CURSOR get_worksheets(p_org_id cn_payruns.org_id%TYPE) IS
35: SELECT payment_worksheet_id,object_version_number
36: FROM cn_payment_worksheets
37: WHERE payrun_id = p_payrun_id
38: AND quota_id IS NULL
39: AND worksheet_status = 'UNPAID'
40: --R12
826:
827:
828: CURSOR get_quotas(p_payrun cn_payruns.payrun_id%TYPE) IS
829: select distinct w.quota_id,q.name
830: from cn_payment_worksheets w,
831: cn_quotas q,cn_salesreps cns
832: where payrun_id=p_payrun
833: and w.quota_id is not null
834: and w.quota_id=q.quota_id
1461: SELECT cns.salesrep_id, pvs.vendor_id supplier_id,
1462: pvc.vendor_site_id supplier_site_id,
1463: currency_code
1464: FROM cn_salesreps cns,
1465: cn_payment_worksheets cnpw,
1466: po_vendor_sites pvs,
1467: po_vendor_contacts pvc
1468: WHERE cnpw.payrun_id = p_payrun_id
1469: AND cnpw.org_id=cns.org_id
1480:
1481: CURSOR get_salesreps IS
1482: SELECT cns.salesrep_id,cns.currency_code,cns.source_id
1483: FROM cn_salesreps cns,
1484: cn_payment_worksheets cnpw
1485: WHERE cnpw.payrun_id = p_payrun_id
1486: AND cnpw.org_id=cns.org_id
1487: AND cnpw.salesrep_id = cns.salesrep_id
1488: AND cnpw.quota_id IS NULL
1681:
1682: FUNCTION populate_ccids
1683: (
1684: p_payrun_id IN cn_payruns.payrun_id%TYPE,
1685: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
1686: --p_start_date IN DATE,
1687: --p_end_date IN DATE,
1688: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1689: p_pmt_tran_id IN cn_payment_transactions.payment_transaction_id%TYPE DEFAULT NULL,
2160: l_old_record get_old_record%ROWTYPE;
2161:
2162: CURSOR get_wksht_csr IS
2163: SELECT payment_worksheet_id
2164: FROM cn_payment_worksheets
2165: WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
2166: AND quota_id IS NULL;
2167:
2168: l_has_access BOOLEAN;
2398: l_old_record get_old_record%ROWTYPE;
2399:
2400: CURSOR get_worksheets IS
2401: SELECT payment_worksheet_id,object_version_number
2402: FROM cn_payment_worksheets
2403: WHERE payrun_id = p_payrun_id
2404: AND quota_id = null;
2405:
2406: G_LAST_UPDATE_DATE DATE := sysdate;
2617: l_api_version CONSTANT NUMBER := 1.0;
2618:
2619: CURSOR get_unpaid_wksht IS
2620: SELECT payment_worksheet_id, salesrep_id
2621: FROM cn_payment_worksheets
2622: WHERE payrun_id = p_payrun_id AND worksheet_status = 'UNPAID'
2623: AND quota_id IS NULL ;
2624:
2625: CURSOR get_unapprove_wksht IS
2623: AND quota_id IS NULL ;
2624:
2625: CURSOR get_unapprove_wksht IS
2626: SELECT payment_worksheet_id, salesrep_id
2627: FROM cn_payment_worksheets
2628: WHERE payrun_id = p_payrun_id AND worksheet_status <> 'APPROVED'
2629: AND quota_id IS NULL;
2630:
2631: BEGIN
2822: l_payrun_rec get_payrun%ROWTYPE;
2823:
2824: CURSOR get_salesreps_in_payrun(p_org_id cn_payruns.org_id%TYPE) IS
2825: SELECT distinct salesrep_id
2826: FROM cn_payment_worksheets
2827: WHERE payrun_id = p_payrun_id
2828: --R12
2829: AND org_id = p_org_id;
2830:
2831: CURSOR get_worksheet_data_for_pe (p_salesrep_id NUMBER, p_org_id cn_payruns.org_id%TYPE)IS
2832: SELECT salesrep_id, quota_id, credit_type_id,
2833: pmt_amount_calc, pmt_amount_adj, pmt_amount_adj_rec,
2834: pmt_amount_adj_nrec, pmt_amount_recovery
2835: FROM cn_payment_worksheets
2836: WHERE payrun_id = p_payrun_id
2837: AND salesrep_id = p_salesrep_id
2838: AND quota_id is not null;
2839:
2912: SELECT nvl(pmt_amount_calc,0),
2913: nvl(pmt_amount_adj_rec,0),
2914: nvl(pmt_amount_adj_nrec,0),
2915: -nvl(pmt_amount_recovery,0)
2916: FROM cn_payment_worksheets
2917: WHERE payrun_id = p_payrun_id
2918: AND salesrep_id = p_salesrep_id
2919: AND credit_type_id = l_credit_type_id
2920: AND (quota_id = p_quota_id