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 530: cn_period_statuses_all ps

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

Line 540: cn_period_statuses_all ps

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

Line 580: cn_period_statuses_all ps

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

Line 590: cn_period_statuses_all ps

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