DBA Data[Home] [Help]

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 666: ff_database_items fdi

662:
663: cursor cur_archive (b_context_id NUMBER, b_user_name VARCHAR2) is
664: select fai.value
665: from ff_archive_items fai,
666: ff_database_items fdi
667: where fai.user_entity_id = fdi.user_entity_id
668: and fai.context1 = b_context_id
669: and fdi.user_name = b_user_name;
670: