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 153: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,

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

Line 154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,

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

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

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

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

152: p_period_year IN cn_period_statuses.period_year%TYPE,
153: p_pay_interval_type_id IN cn_pmt_plans.pay_interval_type_id%TYPE,
154: p_recoverable_interval_type_id IN cn_pmt_plans.recoverable_interval_type_id%TYPE,
155: x_pay_period_id OUT NOCOPY cn_pmt_plans.pay_interval_type_id%TYPE,
156: x_rec_period_id OUT NOCOPY cn_pmt_plans.recoverable_interval_type_id%TYPE,
157: --R12
158: p_org_id IN cn_payruns.org_id%TYPE
159: ) IS
160: 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 183: l_pay_period_id cn_pmt_plans.pay_interval_type_id%TYPE;

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

Line 184: l_rec_period_id cn_pmt_plans.recoverable_interval_type_id%TYPE;

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

Line 237: p_payment_group_code IN cn_pmt_plans.payment_group_code%TYPE

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

Line 281: p_min IN cn_pmt_plans.minimum_amount%TYPE,

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

Line 282: p_min_rec_flag IN cn_pmt_plans.min_rec_flag%TYPE,

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

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

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

Line 973: 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

969: AND org_id = p_org_id;
970:
971: -- Bug 2875120/2892822 : combine 2 cursor
972: -- get the amount paid at the payment group code level
973: 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
974: SELECT nvl(SUM(balance1_dtd - balance1_ctd), 0) payment
975: FROM cn_srp_periods csp,
976: cn_quotas_all q,
977: cn_period_statuses ps

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

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