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_SRP_PAYGROUP_PVT dependencies on DUAL

Line 333: select 1 into l_count from dual where not exists

329: -- Added new checking logic below
330: -- Check if any of the periods after this new assignment end date has been used
331: -- in cn_posting_details, if so error.
332: BEGIN
333: select 1 into l_count from dual where not exists
334: (select 1 from cn_srp_periods_all csp, cn_posting_details_sum_all cpd
335: where cpd.credited_salesrep_id = p_salesrep_id
336: AND cpd.org_id = p_org_id
337: AND cpd.pay_period_id = csp.period_id

Line 552: FROM dual;

548: x_loading_status := 'CN_CREATED';
549:
550: SELECT cn_srp_pay_groups_s.NEXTVAL
551: INTO l_srp_pay_group_id
552: FROM dual;
553:
554: Validate_assignment
555: (x_return_status => x_return_status,
556: x_msg_count => x_msg_count,