APPS.CN_PMT_TRANS_PKG dependencies on CN_REPOSITORIES_ALL

Line 253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr

249: BEGIN
250:
251: SELECT s.org_id, s.status, r.period_set_id, r.period_type_id, NVL(r.payroll_flag,'N')
252: INTO l_org_id, l_status, l_period_set_id, l_period_type_id, l_payroll_flag
253: FROM cn_salesreps s, cn_repositories_all r, cn_payruns_all pr
254: WHERE s.salesrep_id = p_salesrep_id
255: AND s.org_id = r.org_id
256: AND pr.org_id = r.org_id
257: AND pr.payrun_id = p_payrun_id