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.CST_PERIODIC_ABSORPTION_PROC dependencies on CST_PAC_PERIODS

Line 1181: FROM CST_PAC_PERIODS cpp

1177: );
1178:
1179: SELECT count(1)
1180: INTO l_count
1181: FROM CST_PAC_PERIODS cpp
1182: WHERE cpp.pac_period_id = p_period_id
1183: AND TRUNC(cpp.period_end_date) >= l_process_upto_date
1184: AND TRUNC(cpp.period_start_date) <= l_process_upto_date;
1185:

Line 1423: FROM cst_pac_periods cpp

1419: SELECT TO_CHAR(period_start_date,'YYYY/MM/DD HH24:MI:SS')
1420: ,p_process_upto_date
1421: INTO l_start_date
1422: ,l_end_date
1423: FROM cst_pac_periods cpp
1424: WHERE cpp.pac_period_id = p_period_id
1425: AND cpp.legal_entity = p_legal_entity
1426: AND cpp.cost_type_id = p_cost_type_id;
1427:

Line 1529: FROM cst_pac_periods cpp

1525: END IF;
1526:
1527: SELECT nvl(max(cpp.pac_period_id), -1)
1528: INTO l_prev_period_id
1529: FROM cst_pac_periods cpp
1530: WHERE cpp.legal_entity = p_legal_entity
1531: AND cpp.cost_type_id = p_cost_type_id
1532: AND cpp.pac_period_id < p_period_id;
1533:

Line 1539: FROM cst_pac_periods cpp

1535: THEN
1536:
1537: SELECT count(1)
1538: INTO l_period_closed
1539: FROM cst_pac_periods cpp
1540: WHERE cpp.pac_period_id = l_prev_period_id
1541: AND cpp.legal_entity = p_legal_entity
1542: AND cpp.cost_type_id = p_cost_type_id
1543: AND cpp.open_flag = 'N'

Line 1606: FROM cst_pac_periods cpp

1602: END IF;
1603:
1604: SELECT count(1)
1605: INTO l_count
1606: FROM cst_pac_periods cpp
1607: WHERE cpp.legal_entity = p_legal_entity
1608: AND cpp.cost_type_id = p_cost_type_id
1609: AND cpp.pac_period_id = p_period_id
1610: AND cpp.open_flag = 'Y'