DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 307: from ff_database_items fdi

303: declare
304:
305: cursor cur_database_items is
306: select fdi.user_entity_id
307: from ff_database_items fdi
308: where fdi.user_name = p_user_name;
309:
310: l_user_entity_id ff_database_items.user_entity_id%TYPE;
311:

Line 310: l_user_entity_id ff_database_items.user_entity_id%TYPE;

306: select fdi.user_entity_id
307: from ff_database_items fdi
308: where fdi.user_name = p_user_name;
309:
310: l_user_entity_id ff_database_items.user_entity_id%TYPE;
311:
312: begin
313:
314: open cur_database_items;

Line 697: ff_database_items fdi

693:
694: cursor cur_dates (b_assignment_action_id number) is
695: select fnd_date.canonical_to_date(fai.value)
696: from ff_archive_items fai,
697: ff_database_items fdi
698: where fai.user_entity_id = fdi.user_entity_id
699: and fdi.user_name = 'ROE_DATE'
700: and fai.context1 = to_char(b_assignment_action_id);
701:

Line 826: ff_database_items fdi

822:
823: cursor cur_archive_value is
824: select fai.value
825: from ff_archive_items fai,
826: ff_database_items fdi
827: where fdi.user_name = p_user_name
828: and fdi.user_entity_id = fai.user_entity_id
829: and fai.context1 = p_assactid;
830: