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_API dependencies on CN_PERIOD_STATUSES_ALL

Line 101: FROM cn_period_statuses_all

97:
98: BEGIN
99: SELECT period_name
100: INTO l_period_name
101: FROM cn_period_statuses_all
102: WHERE period_id = p_period_id
103: AND org_id = p_org_id
104: AND period_status IN ('F', 'O');
105:

Line 124: FROM cn_period_statuses_all

120:
121: BEGIN
122: SELECT period_id
123: INTO l_period_id
124: FROM cn_period_statuses_all
125: WHERE Upper(period_name) = Upper(p_period_name)
126: AND org_id = p_org_id
127: AND period_status IN ('F', 'O');
128:

Line 1479: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c

1475: BEGIN
1476:
1477: SELECT a.period_id
1478: INTO l_pay_period_id
1479: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1480: WHERE a.period_set_id = c.period_set_id
1481: AND a.org_id = p_org_id
1482: AND a.period_type_id = c.period_type_id
1483: AND b.pay_group_id = c.pay_group_id