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_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_QUOTAS

Line 87: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas

83: (
84: SELECT 1 --if query returns row, then we can't allow update/delete.
85: --if query doesnot return anything, we can do update/delete.
86: FROM
87: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas
88: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
89: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
90: FROM cn_period_statuses ps,
91: cn_payment_transactions pt,

Line 94: cn_quotas cq

90: FROM cn_period_statuses ps,
91: cn_payment_transactions pt,
92: cn_quota_pay_elements qpe,
93: cn_salesreps cs,
94: cn_quotas cq
95: WHERE pt.credited_salesrep_id = cs.salesrep_id
96: AND pt.pay_period_id = ps.period_id
97: AND pt.pay_element_type_id = qpe.pay_element_type_id
98: AND cq.quota_id = DECODE(pt.quota_id,-1000, cq.quota_id, pt.quota_id)

Line 116: cn_quotas cq

112: FROM cn_period_statuses ps,
113: cn_payment_transactions pt,
114: cn_quota_pay_elements qpe,
115: cn_salesreps cs,
116: cn_quotas cq
117: WHERE pt.credited_salesrep_id = cs.salesrep_id
118: AND pt.pay_period_id = ps.period_id
119: AND pt.pay_element_type_id = qpe.pay_element_type_id
120: AND cq.quota_id = DECODE(pt.quota_id,-1000, cq.quota_id, pt.quota_id)

Line 155: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas

151: (
152: SELECT 1 --if query returns row, then we can't allow update/delete.
153: --if query doesnot return anything, we can do update/delete.
154: FROM
155: (--Quota_id is -1000 as carry over and regular quota_id as in cn_quotas
156: SELECT qpe.quota_pay_element_id,qpe.quota_id,qpe.pay_element_type_id,qpe.status,
157: MIN(ps.start_date) start_date, MAX(ps.end_date) end_date
158: FROM cn_period_statuses ps,
159: cn_payment_transactions pt,

Line 162: cn_quotas cq

158: FROM cn_period_statuses ps,
159: cn_payment_transactions pt,
160: cn_quota_pay_elements qpe,
161: cn_salesreps cs,
162: cn_quotas cq
163: WHERE pt.credited_salesrep_id = cs.salesrep_id
164: AND pt.pay_period_id = ps.period_id
165: AND pt.pay_element_type_id = qpe.pay_element_type_id
166: AND cq.quota_id = DECODE(pt.quota_id,-1000, cq.quota_id, pt.quota_id)

Line 184: cn_quotas cq

180: FROM cn_period_statuses ps,
181: cn_payment_transactions pt,
182: cn_quota_pay_elements qpe,
183: cn_salesreps cs,
184: cn_quotas cq
185: WHERE pt.credited_salesrep_id = cs.salesrep_id
186: AND pt.pay_period_id = ps.period_id
187: AND pt.pay_element_type_id = qpe.pay_element_type_id
188: AND cq.quota_id = DECODE(pt.quota_id,-1000, cq.quota_id, pt.quota_id)

Line 218: --| Modified by Julia Huang on 5/12/04 for bug 3626385. Use cn_quotas and

214: END ;
215: --+==========================================================================
216: --| Function : get quota ID
217: --| Desc :
218: --| Modified by Julia Huang on 5/12/04 for bug 3626385. Use cn_quotas and
219: --| cn_lookups instead of cn_quota_lookups_v.
220: --+==========================================================================
221: FUNCTION get_Quota_id( p_quota_name VARCHAR2)
222: RETURN cn_quotas.quota_id%TYPE IS

Line 222: RETURN cn_quotas.quota_id%TYPE IS

218: --| Modified by Julia Huang on 5/12/04 for bug 3626385. Use cn_quotas and
219: --| cn_lookups instead of cn_quota_lookups_v.
220: --+==========================================================================
221: FUNCTION get_Quota_id( p_quota_name VARCHAR2)
222: RETURN cn_quotas.quota_id%TYPE IS
223:
224: l_quota_id cn_quotas.quota_id%TYPE;
225:
226: --Bug 3626385

Line 224: l_quota_id cn_quotas.quota_id%TYPE;

220: --+==========================================================================
221: FUNCTION get_Quota_id( p_quota_name VARCHAR2)
222: RETURN cn_quotas.quota_id%TYPE IS
223:
224: l_quota_id cn_quotas.quota_id%TYPE;
225:
226: --Bug 3626385
227: l_cnt NUMBER;
228:

Line 231: FROM cn_quotas

227: l_cnt NUMBER;
228:
229: CURSOR get_qid_quotas IS
230: SELECT quota_id
231: FROM cn_quotas
232: WHERE name = p_quota_name;
233:
234: CURSOR get_qid_lkup IS
235: SELECT v.quota_id

Line 1079: p_quota_name IN cn_quotas.name%TYPE,

1075: p_validation_level IN NUMBER,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_quota_name IN cn_quotas.name%TYPE,
1080: p_pay_element_name IN pay_element_types.element_name%TYPE,
1081: p_start_record IN NUMBER,
1082: p_increment_count IN NUMBER,
1083: p_order_by IN VARCHAR2,

Line 1107: l_quota_name cn_quotas.name%type;

1103: l_status cn_quota_pay_elements.status%TYPE;
1104: l_start_date DATE;
1105: l_end_date DATE;
1106:
1107: l_quota_name cn_quotas.name%type;
1108: l_element_name pay_element_types.element_name%TYPE;
1109: l_e_start_date DATE;
1110: l_e_end_date DATE;
1111: