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_PMT_PLANS

Line 151: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,

147: (
148: p_period_id IN cn_period_statuses.period_id%TYPE,
149: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
150: p_period_year IN cn_period_statuses.period_year%TYPE,
151: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12

Line 152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,

148: p_period_id IN cn_period_statuses.period_id%TYPE,
149: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
150: p_period_year IN cn_period_statuses.period_year%TYPE,
151: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12
156: p_org_id IN cn_payruns.org_id%TYPE

Line 153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,

149: p_quarter_num IN cn_period_statuses.quarter_num%TYPE,
150: p_period_year IN cn_period_statuses.period_year%TYPE,
151: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12
156: p_org_id IN cn_payruns.org_id%TYPE
157: ) IS

Line 154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,

150: p_period_year IN cn_period_statuses.period_year%TYPE,
151: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
152: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
153: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
154: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: --R12
156: p_org_id IN cn_payruns.org_id%TYPE
157: ) IS
158: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS

Line 181: l_pay_period_id cn_pmt_plans.pay_interval_type_id%TYPE;

177: --R12
178: AND p.org_id = p_org_id
179: AND pt.org_id = p_org_id;
180:
181: l_pay_period_id cn_pmt_plans.pay_interval_type_id%TYPE;
182: l_rec_period_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
183: BEGIN
184: IF p_pay_interval_type_id = -1000 --pay interval is period
185: THEN

Line 182: l_rec_period_id cn_pmt_plans.recoverable_interval_type_id%TYPE;

178: AND p.org_id = p_org_id
179: AND pt.org_id = p_org_id;
180:
181: l_pay_period_id cn_pmt_plans.pay_interval_type_id%TYPE;
182: l_rec_period_id cn_pmt_plans.recoverable_interval_type_id%TYPE;
183: BEGIN
184: IF p_pay_interval_type_id = -1000 --pay interval is period
185: THEN
186: l_pay_period_id := p_period_id;

Line 235: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE

231: (
232: p_payrun_id IN cn_payruns.payrun_id%TYPE,
233: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
234: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
235: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE
236: ) IS
237: BEGIN
238: IF p_incentive_type = 'ALL'
239: OR p_incentive_type IS NULL

Line 279: p_min IN cn_pmt_plans.minimum_amount%TYPE,

275: -- Calls :
276: -- ===========================================================================
277: PROCEDURE give_min_as_pmt_plan
278: (
279: p_min IN cn_pmt_plans.minimum_amount%TYPE,
280: p_min_rec_flag IN cn_pmt_plans.min_rec_flag%TYPE,
281: x_pmt_amount_adj_rec OUT NOCOPY NUMBER,
282: x_pmt_amount_adj_nrec OUT NOCOPY NUMBER
283: ) IS

Line 280: p_min_rec_flag IN cn_pmt_plans.min_rec_flag%TYPE,

276: -- ===========================================================================
277: PROCEDURE give_min_as_pmt_plan
278: (
279: p_min IN cn_pmt_plans.minimum_amount%TYPE,
280: p_min_rec_flag IN cn_pmt_plans.min_rec_flag%TYPE,
281: x_pmt_amount_adj_rec OUT NOCOPY NUMBER,
282: x_pmt_amount_adj_nrec OUT NOCOPY NUMBER
283: ) IS
284: l_pmt_amount_adj_rec NUMBER := 0;

Line 485: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE, --bug 3175375 by jjhuang.

481: (
482: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
483: p_incentive_type IN cn_payruns.incentive_type_code%TYPE,
484: p_payrun_id IN cn_payruns.payrun_id%TYPE,
485: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE, --bug 3175375 by jjhuang.
486: p_applied_pgc IN dbms_sql.varchar2_table, --bug 3198445 by jjhuang.
487: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
488: --R12
489: p_org_id IN cn_payruns.org_id%TYPE

Line 971: CURSOR get_itd_amount_paid(p_period_set_id NUMBER, p_period_type_id NUMBER, p_interval_sdate DATE, p_interval_edate DATE, p_pg_code cn_pmt_plans.payment_group_code%TYPE) IS

967: AND org_id = p_org_id;
968:
969: -- Bug 2875120/2892822 : combine 2 cursor
970: -- get the amount paid at the payment group code level
971: CURSOR get_itd_amount_paid(p_period_set_id NUMBER, p_period_type_id NUMBER, p_interval_sdate DATE, p_interval_edate DATE, p_pg_code cn_pmt_plans.payment_group_code%TYPE) IS
972: SELECT nvl(SUM(balance1_dtd - balance1_ctd), 0) payment
973: FROM cn_srp_periods csp,
974: cn_quotas_all q,
975: cn_period_statuses ps

Line 1042: ' FROM cn_srp_pmt_plans cspp,cn_pmt_plans cnpp,cn_period_statuses cnps ' || ' WHERE ' || ' cspp.salesrep_id = :p_salesrep_id' ||

1038: ' cnpp.recoverable_interval_type_id,' || ' nvl(cnpp.pay_against_commission, ''Y'') pay_against_commission,' || ' cnpp.payment_group_code,' ||
1039: ' cspp.minimum_amount,' || ' cnpp.min_rec_flag,' || ' cnpp.max_rec_flag,' || ' cspp.maximum_amount,' || ' cnps.period_id,' ||
1040: ' cspp.salesrep_id,' || ' cnps.start_date prd_start_date,' || ' cnps.end_date prd_end_date,' || ' cnpp.name,' ||
1041: ' ROW_NUMBER() over (PARTITION BY cnpp.payment_group_code' || ' ORDER BY cspp.start_date DESC) AS row_nums ,' || ' cnpp.credit_type_id' ||
1042: ' FROM cn_srp_pmt_plans cspp,cn_pmt_plans cnpp,cn_period_statuses cnps ' || ' WHERE ' || ' cspp.salesrep_id = :p_salesrep_id' ||
1043: ' AND cnpp.pmt_plan_id = cspp.pmt_plan_id ' || ' AND cnps.period_id = :p_period_id' || ' AND cnpp.credit_type_id = -1000' ||
1044: ' AND cspp.start_date <= cnps.end_date' ||
1045: -- ' AND Nvl(cspp.end_date,cnps.start_date) >= cnps.start_date' ||
1046: --bug 3395792 by jjhuang on 1/23/04