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 1366: l_payables_flag cn_repositories.payables_flag%TYPE;

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

Line 1367: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;

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

Line 1376: FROM cn_repositories

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

Line 2367: FROM cn_repositories rp,

2363: CURSOR get_apps IS
2364: SELECT payables_flag,
2365: payroll_flag,
2366: payables_ccid_level
2367: FROM cn_repositories rp,
2368: cn_payment_worksheets wk
2369: WHERE rp.org_id = wk.org_id;
2370:
2371: wksht_rec get_worksheet_id%ROWTYPE;

Line 2388: l_payables_flag cn_repositories.payables_flag%TYPE;

2384: l_pmt_amount_ctr NUMBER;
2385: l_rowid VARCHAR2(30);
2386: -- changes for bug#2568937
2387: -- for payroll integration population of account
2388: l_payables_flag cn_repositories.payables_flag%TYPE;
2389: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2390: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2391: l_ispayee NUMBER := 0;
2392: TYPE num_tab IS TABLE OF NUMBER;

Line 2389: l_payroll_flag cn_repositories.payroll_flag%TYPE;

2385: l_rowid VARCHAR2(30);
2386: -- changes for bug#2568937
2387: -- for payroll integration population of account
2388: l_payables_flag cn_repositories.payables_flag%TYPE;
2389: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2390: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2391: l_ispayee NUMBER := 0;
2392: TYPE num_tab IS TABLE OF NUMBER;
2393: l_wk_plan_elements num_tab;

Line 2390: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;

2386: -- changes for bug#2568937
2387: -- for payroll integration population of account
2388: l_payables_flag cn_repositories.payables_flag%TYPE;
2389: l_payroll_flag cn_repositories.payroll_flag%TYPE;
2390: l_payables_ccid_level cn_repositories.payables_ccid_level%TYPE;
2391: l_ispayee NUMBER := 0;
2392: TYPE num_tab IS TABLE OF NUMBER;
2393: l_wk_plan_elements num_tab;
2394: l_has_access BOOLEAN;

Line 2451: cn_repositories_all r,

2447: INTO l_srp_status,
2448: l_payroll_flag,
2449: l_payables_flag
2450: FROM cn_salesreps s,
2451: cn_repositories_all r,
2452: cn_payruns_all pr
2453: WHERE s.salesrep_id = wksht_rec.salesrep_id
2454: AND s.org_id = r.org_id
2455: AND pr.org_id = r.org_id

Line 2506: cn_repositories r

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

Line 2541: cn_repositories r

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

Line 2616: cn_repositories r

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

Line 2723: cn_repositories r

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

Line 3067: cn_repositories r

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

Line 3141: cn_repositories r

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