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.PAY_CA_T4A_MAG dependencies on FF_DATABASE_ITEMS

Line 58: from ff_database_items

54: Function get_user_entity_id(p_user_name varchar2) return number is
55:
56: cursor cur_user_entity_id is
57: select user_entity_id
58: from ff_database_items
59: where user_name = p_user_name;
60:
61: l_user_entity_id ff_database_items.user_entity_id%TYPE;
62:

Line 61: l_user_entity_id ff_database_items.user_entity_id%TYPE;

57: select user_entity_id
58: from ff_database_items
59: where user_name = p_user_name;
60:
61: l_user_entity_id ff_database_items.user_entity_id%TYPE;
62:
63: begin
64:
65: open cur_user_entity_id;

Line 674: from ff_database_items fdi,

670: lv_value varchar2(60);
671:
672: cursor c_get_dbitem_value(cp_dbitem varchar2) is
673: select fai.value
674: from ff_database_items fdi,
675: ff_archive_items fai
676: where fai.user_entity_id=fdi.user_entity_id
677: and fai.context1= p_asg_act_id
678: and fdi.user_name = cp_dbitem;

Line 1283: ff_database_items fdi

1279:
1280: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
1281: select fai.value
1282: from ff_archive_items fai,
1283: ff_database_items fdi
1284: where fai.user_entity_id = fdi.user_entity_id
1285: and fai.context1 = b_context_id
1286: and fdi.user_name = b_user_name;
1287: