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.

[Home] [Help]

APPS.CN_API dependencies on CN_PERIOD_STATUSES_ALL

Line 123: FROM cn_period_statuses_all

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

Line 146: FROM cn_period_statuses_all

142:
143: BEGIN
144: SELECT period_id
145: INTO l_period_id
146: FROM cn_period_statuses_all
147: WHERE Upper(period_name) = Upper(p_period_name)
148: AND org_id = p_org_id
149: AND period_status IN ('F', 'O');
150:

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

1497: BEGIN
1498:
1499: SELECT a.period_id
1500: INTO l_pay_period_id
1501: FROM cn_period_statuses_all a, cn_srp_pay_groups_all b, cn_pay_groups_all c
1502: WHERE a.period_set_id = c.period_set_id
1503: AND a.org_id = p_org_id
1504: AND a.period_type_id = c.period_type_id
1505: AND b.pay_group_id = c.pay_group_id