APPS.CN_PMT_TRANS_PKG dependencies on CN_QUOTA_PAY_ELEMENTS

Line 217: cn_quota_pay_elements_all qp,

213: q.incentive_type_code,
214: DECODE (r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id
215: FROM cn_srp_periods srp,
216: cn_quotas_all q,
217: cn_quota_pay_elements_all qp,
218: cn_rs_salesreps s,
219: cn_repositories r
220: WHERE srp.salesrep_id = p_salesrep_id
221: AND srp.period_id = p_pay_period_id

Line 441: cn_quota_pay_elements_all qp,

437: g_last_update_login,--Bug 3080846 for who columns
438: srp.org_id,
439: 1
440: FROM cn_srp_periods srp,
441: cn_quota_pay_elements_all qp,
442: cn_rs_salesreps s,
443: cn_repositories r
444: WHERE srp.salesrep_id = p_salesrep_id
445: AND srp.period_id = p_pay_period_id

Line 544: cn_quota_pay_elements_all qp,

540: 1,
541: cl.processed_date
542: FROM cn_commission_lines cl,
543: cn_quotas_all pe,
544: cn_quota_pay_elements_all qp,
545: cn_srp_payee_assigns_all spayee
546: WHERE cl.srp_payee_assign_id IS NOT NULL
547: AND cl.srp_payee_assign_id = spayee.srp_payee_assign_id
548: AND spayee.payee_id = p_salesrep_id

Line 654: cn_quota_pay_elements_all qp

650: 1,
651: cl.processed_date
652: FROM cn_commission_lines cl,
653: cn_quotas_all pe,
654: cn_quota_pay_elements_all qp
655: WHERE cl.credited_salesrep_id = p_salesrep_id
656: AND cl.processed_period_id <= p_pay_period_id
657: AND cl.status = 'CALC'
658: AND cl.posting_status = 'UNPOSTED'

Line 687: FROM cn_quota_pay_elements p

683: UPDATE cn_payment_transactions ptx
684: SET payrun_id = p_payrun_id,
685: pay_element_type_id =
686: (SELECT DECODE (l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
687: FROM cn_quota_pay_elements p
688: WHERE p.quota_id = ptx.quota_id
689: AND p_pay_date BETWEEN p.start_date AND p.end_date
690: AND NVL (l_status, 'A') = p.status),
691: --bug 3080846

Line 712: FROM cn_quota_pay_elements p

708: UPDATE cn_payment_transactions ptx
709: SET payrun_id = p_payrun_id,
710: pay_element_type_id =
711: (SELECT DECODE (l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
712: FROM cn_quota_pay_elements p
713: WHERE p.quota_id = ptx.quota_id
714: AND p_pay_date BETWEEN p.start_date AND p.end_date
715: AND NVL (l_status, 'A') = p.status),
716: --bug 3080846

Line 740: FROM cn_quota_pay_elements p

736: UPDATE cn_payment_transactions ptx
737: SET payrun_id = p_payrun_id,
738: pay_element_type_id =
739: (SELECT DECODE (l_payroll_flag, 'Y', p.pay_element_type_id, NULL) pay_element_type_id
740: FROM cn_quota_pay_elements p
741: WHERE p.quota_id = -1001
742: AND p_pay_date BETWEEN p.start_date AND p.end_date
743: AND NVL (l_status, 'A') = p.status
744: AND p.org_id = p_org_id),