APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_QUOTA_PAY_ELEMENTS

Line 2550: FROM cn_quota_pay_elements p,

2546: AND csp.credit_type_id = cnpt.credit_type_id
2547: --R12
2548: AND csp.org_id = wksht_rec.org_id),
2549: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
2550: FROM cn_quota_pay_elements p,
2551: cn_rs_salesreps s,
2552: cn_repositories r
2553: WHERE p.quota_id = cnpt.quota_id
2554: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 2585: FROM cn_quota_pay_elements p,

2581: AND csp.credit_type_id = cnpt.credit_type_id
2582: --R12
2583: AND csp.org_id = wksht_rec.org_id),
2584: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
2585: FROM cn_quota_pay_elements p,
2586: cn_rs_salesreps s,
2587: cn_repositories r
2588: WHERE p.quota_id = cnpt.quota_id
2589: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 2660: cn_quota_pay_elements_all qp,

2656: srp.quota_id,
2657: decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
2658: FROM cn_srp_periods srp,
2659: cn_quotas_all q,
2660: cn_quota_pay_elements_all qp,
2661: cn_rs_salesreps s,
2662: cn_repositories r
2663: -- 01/03/03 gasriniv added hold flag check for bug 2710066
2664: WHERE srp.salesrep_id = wksht_rec.salesrep_id

Line 2767: cn_quota_pay_elements_all qp,

2763: SYSDATE,
2764: --R12
2765: wksht_rec.org_id
2766: FROM cn_srp_periods srp,
2767: cn_quota_pay_elements_all qp,
2768: cn_rs_salesreps s,
2769: cn_repositories r
2770: WHERE srp.salesrep_id = wksht_rec.salesrep_id
2771: AND srp.period_id = wksht_rec.pay_period_id

Line 2925: cn_quota_pay_elements qp

2921: 1,
2922: cl.processed_date
2923: FROM cn_commission_lines cl,
2924: cn_quotas_all pe,
2925: cn_quota_pay_elements qp
2926: WHERE cl.credited_salesrep_id = wksht_rec.salesrep_id
2927: AND cl.processed_period_id <= wksht_rec.pay_period_id
2928: AND cl.processed_date <= wksht_rec.pay_date
2929: AND cl.status = 'CALC'

Line 3025: cn_quota_pay_elements_all qp

3021: cl.processed_date
3022: FROM cn_commission_lines cl,
3023: cn_srp_payee_assigns_all spayee,
3024: cn_quotas_all pe,
3025: cn_quota_pay_elements_all qp
3026: WHERE cl.srp_payee_assign_id IS NOT NULL
3027: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
3028: AND spayee.payee_id = wksht_rec.salesrep_id
3029: AND cl.credited_salesrep_id = spayee.salesrep_id

Line 3055: FROM cn_quota_pay_elements p

3051: -- update payrun id on all payment transactions
3052: UPDATE cn_payment_transactions cnpt
3053: SET payrun_id = wksht_rec.payrun_id,
3054: pay_element_type_id = (SELECT decode(l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3055: FROM cn_quota_pay_elements p
3056: WHERE p.quota_id = cnpt.quota_id
3057: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3058: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))),
3059: last_update_date = SYSDATE,

Line 3074: FROM cn_quota_pay_elements p

3070:
3071: -- update pay_element_type_id
3072: UPDATE cn_payment_transactions cnpt
3073: SET pay_element_type_id = (SELECT decode(l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3074: FROM cn_quota_pay_elements p
3075: WHERE p.quota_id = decode(cnpt.incentive_type_code, 'PMTPLN_REC', -1001, cnpt.quota_id)
3076: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3077: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))
3078: AND p.org_id = wksht_rec.org_id),

Line 3111: FROM cn_quota_pay_elements p,

3107: UPDATE cn_payment_transactions cnpt
3108: SET amount = l_calc_rec_tbl(i).pmt_amount_adj_rec + l_calc_rec_tbl(i).pmt_amount_adj_nrec,
3109: payment_amount = l_calc_rec_tbl(i).pmt_amount_adj_rec + l_calc_rec_tbl(i).pmt_amount_adj_nrec,
3110: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3111: FROM cn_quota_pay_elements p,
3112: cn_rs_salesreps s,
3113: cn_repositories r
3114: WHERE p.quota_id = cnpt.quota_id
3115: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date

Line 3185: FROM cn_quota_pay_elements p,

3181: UPDATE cn_payment_transactions cnpt
3182: SET amount = 0,
3183: payment_amount = 0,
3184: pay_element_type_id = (SELECT decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
3185: FROM cn_quota_pay_elements p,
3186: cn_rs_salesreps s,
3187: cn_repositories r
3188: WHERE p.quota_id = cnpt.quota_id
3189: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date