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.FII_AP_INV_ACTIVITY dependencies on DUAL

Line 1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;

1228:
1229: CASE l_period_type
1230: WHEN 'FII_TIME_WEEK' THEN
1231: p_period_id := 16;
1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;
1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;
1234: select sequence into p_cur_effective_num
1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;

Line 1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;

1229: CASE l_period_type
1230: WHEN 'FII_TIME_WEEK' THEN
1231: p_period_id := 16;
1232: select nvl(fii_time_api.pwk_end(l_as_of_date-91) +1, l_start_date) into p_report_start from dual;
1233: select nvl(fii_time_api.pwk_end(l_as_of_date) +1, l_start_date-1) into p_period_start from dual;
1234: select sequence into p_cur_effective_num
1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN

Line 1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;

1235: from fii_time_week
1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN
1238: p_period_id := 32;
1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;
1241: select sequence into p_cur_effective_num
1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;

Line 1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;

1236: where l_as_of_date between start_date and end_date;
1237: WHEN 'FII_TIME_ENT_PERIOD' THEN
1238: p_period_id := 32;
1239: select nvl(fii_time_api.ent_lysper_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1240: select nvl(fii_time_api.ent_cper_start(l_as_of_date), l_start_date) into p_period_start from dual;
1241: select sequence into p_cur_effective_num
1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN

Line 1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;

1242: from fii_time_ent_period
1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN
1245: p_period_id := 64;
1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1248:
1249: select sequence into p_cur_effective_num
1250: from fii_time_ent_qtr

Line 1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;

1243: where l_as_of_date between start_date and end_date;
1244: WHEN 'FII_TIME_ENT_QTR' THEN
1245: p_period_id := 64;
1246: select nvl(fii_time_api.ent_lysqtr_end(l_as_of_date), l_start_date-1) into p_report_start from dual;
1247: select nvl(fii_time_api.ent_cqtr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1248:
1249: select sequence into p_cur_effective_num
1250: from fii_time_ent_qtr
1251: where l_as_of_date between start_date and end_date;

Line 1257: into p_report_start from dual; /* Bug 3325387 */

1253: p_period_id := 128;
1254: --p_report_start := fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date))));
1255:
1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)
1257: into p_report_start from dual; /* Bug 3325387 */
1258:
1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1260: select sequence into p_cur_effective_num
1261: from fii_time_ent_year

Line 1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;

1255:
1256: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_as_of_date)))),l_start_date-1)
1257: into p_report_start from dual; /* Bug 3325387 */
1258:
1259: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into p_period_start from dual;
1260: select sequence into p_cur_effective_num
1261: from fii_time_ent_year
1262: where l_as_of_date between start_date and end_date;
1263: END CASE;