eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_REPOSITORIES

Line 1368: l_payables_flag cn_repositories.payables_flag%TYPE;

1364: l_wk_plan_elements num_tab;
1365:
1366: -- changes for bug#2568937
1367: -- for ap integration population of account
1368: l_payables_flag cn_repositories.payables_flag%TYPE;
1369: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
1370:
1371: -- changes for bug#2568937
1372: -- for ap integration population of account

Line 1369: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;

1365:
1366: -- changes for bug#2568937
1367: -- for ap integration population of account
1368: l_payables_flag cn_repositories.payables_flag%TYPE;
1369: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
1370:
1371: -- changes for bug#2568937
1372: -- for ap integration population of account
1373: --R12

Line 1378: FROM cn_repositories

1374: CURSOR get_apps IS
1375: SELECT payables_flag,
1376: payroll_flag,
1377: payables_ccid_level
1378: FROM cn_repositories
1379: WHERE org_id = p_worksheet_rec.org_id;
1380:
1381: CURSOR get_worksheet IS
1382: SELECT 1

Line 2413: FROM cn_repositories rp,

2409: CURSOR get_apps IS
2410: SELECT payables_flag,
2411: payroll_flag,
2412: payables_ccid_level
2413: FROM cn_repositories rp,
2414: cn_payment_worksheets wk
2415: WHERE rp.org_id = wk.org_id;
2416:
2417: wksht_rec get_worksheet_id%ROWTYPE;

Line 2434: l_payables_flag cn_repositories.payables_flag%TYPE;

2430: l_pmt_amount_ctr NUMBER;
2431: l_rowid VARCHAR2(30);
2432: -- changes for bug#2568937
2433: -- for payroll integration population of account
2434: l_payables_flag cn_repositories.payables_flag%TYPE;
2435: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2436: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2437: l_ispayee NUMBER := 0;
2438: TYPE num_tab IS TABLE OF NUMBER;

Line 2435: l_payroll_flag cn_repositories.payroll_flag%TYPE;

2431: l_rowid VARCHAR2(30);
2432: -- changes for bug#2568937
2433: -- for payroll integration population of account
2434: l_payables_flag cn_repositories.payables_flag%TYPE;
2435: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2436: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2437: l_ispayee NUMBER := 0;
2438: TYPE num_tab IS TABLE OF NUMBER;
2439: l_wk_plan_elements num_tab;

Line 2436: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;

2432: -- changes for bug#2568937
2433: -- for payroll integration population of account
2434: l_payables_flag cn_repositories.payables_flag%TYPE;
2435: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2436: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2437: l_ispayee NUMBER := 0;
2438: TYPE num_tab IS TABLE OF NUMBER;
2439: l_wk_plan_elements num_tab;
2440: l_has_access BOOLEAN;

Line 2497: cn_repositories_all r,

2493: INTO l_srp_status,
2494: l_payroll_flag,
2495: l_payables_flag
2496: FROM cn_salesreps s,
2497: cn_repositories_all r,
2498: cn_payruns_all pr
2499: WHERE s.salesrep_id = wksht_rec.salesrep_id
2500: AND s.org_id = r.org_id
2501: AND pr.org_id = r.org_id

Line 2552: cn_repositories r

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
2555: AND s.salesrep_id = cnpt.credited_salesrep_id
2556: AND nvl(s.status, 'A') = p.status

Line 2587: cn_repositories r

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
2590: AND s.salesrep_id = cnpt.credited_salesrep_id
2591: AND nvl(s.status, 'A') = p.status

Line 2662: cn_repositories r

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
2665: AND srp.period_id = wksht_rec.pay_period_id
2666: AND srp.quota_id = q.quota_id

Line 2769: cn_repositories r

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
2772: AND srp.credit_type_id = -1000
2773: AND srp.quota_id = -1000

Line 3113: cn_repositories r

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
3116: AND s.salesrep_id = cnpt.credited_salesrep_id
3117: AND nvl(s.status, 'A') = p.status

Line 3187: cn_repositories r

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
3190: AND s.salesrep_id = cnpt.credited_salesrep_id
3191: AND nvl(s.status, 'A') = p.status