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_PERIOD_STATUSES_ALL

Line 528: cn_period_statuses_all ps

524: AND NOT EXISTS (
525: -- separate queries for performance reasons. merge cartesian reported
526: SELECT 1
527: FROM cn_srp_payee_assigns_all spayee,
528: cn_period_statuses_all ps
529: WHERE (spayee.salesrep_id = p_salesrep_id)
530: AND ps.period_id = cnp.pay_period_id
531: AND ps.end_date >= spayee.start_date
532: AND ps.org_id = p_org_id

Line 538: cn_period_statuses_all ps

534: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
535: UNION ALL
536: SELECT 1
537: FROM cn_srp_payee_assigns_all spayee,
538: cn_period_statuses_all ps
539: WHERE spayee.payee_id = p_salesrep_id
540: AND ps.period_id = cnp.pay_period_id
541: AND ps.end_date >= spayee.start_date
542: AND ps.org_id = p_org_id

Line 578: cn_period_statuses_all ps

574: AND NOT EXISTS (
575: -- separate queries for performance reasons. merge cartesian reported
576: SELECT 1
577: FROM cn_srp_payee_assigns_all spayee,
578: cn_period_statuses_all ps
579: WHERE (spayee.salesrep_id = p_salesrep_id)
580: AND ps.period_id = cnp.pay_period_id
581: AND ps.end_date >= spayee.start_date
582: AND ps.org_id = p_org_id

Line 588: cn_period_statuses_all ps

584: AND ps.start_date <= nvl(spayee.end_date, ps.end_date)
585: UNION ALL
586: SELECT 1
587: FROM cn_srp_payee_assigns_all spayee,
588: cn_period_statuses_all ps
589: WHERE spayee.payee_id = p_salesrep_id
590: AND ps.period_id = cnp.pay_period_id
591: AND ps.end_date >= spayee.start_date
592: AND ps.org_id = p_org_id