APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_QUOTA_PAY_ELEMENTS

Line 2504: FROM cn_quota_pay_elements p,

2500: AND csp.credit_type_id = cnpt.credit_type_id
2501: --R12
2502: AND csp.org_id = wksht_rec.org_id),
2503: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
2504: FROM cn_quota_pay_elements p,
2505: cn_rs_salesreps s,
2506: cn_repositories r
2507: WHERE p.quota_id = cnpt.quota_id
2508: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 2539: FROM cn_quota_pay_elements p,

2535: AND csp.credit_type_id = cnpt.credit_type_id
2536: --R12
2537: AND csp.org_id = wksht_rec.org_id),
2538: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
2539: FROM cn_quota_pay_elements p,
2540: cn_rs_salesreps s,
2541: cn_repositories r
2542: WHERE p.quota_id = cnpt.quota_id
2543: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 2614: cn_quota_pay_elements_all qp,

2610: srp.quota_id,
2611: decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
2612: FROM cn_srp_periods srp,
2613: cn_quotas_all q,
2614: cn_quota_pay_elements_all qp,
2615: cn_rs_salesreps s,
2616: cn_repositories r
2617: -- 01/03/03 gasriniv added hold flag check for bug 2710066
2618: WHERE srp.salesrep_id = wksht_rec.salesrep_id

Line 2721: cn_quota_pay_elements_all qp,

2717: SYSDATE,
2718: --R12
2719: wksht_rec.org_id
2720: FROM cn_srp_periods srp,
2721: cn_quota_pay_elements_all qp,
2722: cn_rs_salesreps s,
2723: cn_repositories r
2724: WHERE srp.salesrep_id = wksht_rec.salesrep_id
2725: AND srp.period_id = wksht_rec.pay_period_id

Line 2879: cn_quota_pay_elements qp

2875: 1,
2876: cl.processed_date
2877: FROM cn_commission_lines cl,
2878: cn_quotas_all pe,
2879: cn_quota_pay_elements qp
2880: WHERE cl.credited_salesrep_id = wksht_rec.salesrep_id
2881: AND cl.processed_period_id <= wksht_rec.pay_period_id
2882: AND cl.processed_date <= wksht_rec.pay_date
2883: AND cl.status = 'CALC'

Line 2979: cn_quota_pay_elements_all qp

2975: cl.processed_date
2976: FROM cn_commission_lines cl,
2977: cn_srp_payee_assigns_all spayee,
2978: cn_quotas_all pe,
2979: cn_quota_pay_elements_all qp
2980: WHERE cl.srp_payee_assign_id IS NOT NULL
2981: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
2982: AND spayee.payee_id = wksht_rec.salesrep_id
2983: AND cl.credited_salesrep_id = spayee.salesrep_id

Line 3009: FROM cn_quota_pay_elements p

3005: -- update payrun id on all payment transactions
3006: UPDATE cn_payment_transactions cnpt
3007: SET payrun_id = wksht_rec.payrun_id,
3008: pay_element_type_id = (SELECT decode(l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3009: FROM cn_quota_pay_elements p
3010: WHERE p.quota_id = cnpt.quota_id
3011: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3012: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))),
3013: last_update_date = SYSDATE,

Line 3028: FROM cn_quota_pay_elements p

3024:
3025: -- update pay_element_type_id
3026: UPDATE cn_payment_transactions cnpt
3027: SET pay_element_type_id = (SELECT decode(l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3028: FROM cn_quota_pay_elements p
3029: WHERE p.quota_id = decode(cnpt.incentive_type_code, 'PMTPLN_REC', -1001, cnpt.quota_id)
3030: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3031: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))
3032: AND p.org_id = wksht_rec.org_id),

Line 3065: FROM cn_quota_pay_elements p,

3061: UPDATE cn_payment_transactions cnpt
3062: SET amount = l_calc_rec_tbl(i).pmt_amount_adj_rec + l_calc_rec_tbl(i).pmt_amount_adj_nrec,
3063: payment_amount = l_calc_rec_tbl(i).pmt_amount_adj_rec + l_calc_rec_tbl(i).pmt_amount_adj_nrec,
3064: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3065: FROM cn_quota_pay_elements p,
3066: cn_rs_salesreps s,
3067: cn_repositories r
3068: WHERE p.quota_id = cnpt.quota_id
3069: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 3139: FROM cn_quota_pay_elements p,

3135: UPDATE cn_payment_transactions cnpt
3136: SET amount = 0,
3137: payment_amount = 0,
3138: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3139: FROM cn_quota_pay_elements p,
3140: cn_rs_salesreps s,
3141: cn_repositories r
3142: WHERE p.quota_id = cnpt.quota_id
3143: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date