DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 311: from ff_database_items fdi

307: declare
308:
309: cursor cur_database_items is
310: select fdi.user_entity_id
311: from ff_database_items fdi
312: where fdi.user_name = p_user_name;
313:
314: l_user_entity_id ff_database_items.user_entity_id%TYPE;
315:

Line 314: l_user_entity_id ff_database_items.user_entity_id%TYPE;

310: select fdi.user_entity_id
311: from ff_database_items fdi
312: where fdi.user_name = p_user_name;
313:
314: l_user_entity_id ff_database_items.user_entity_id%TYPE;
315:
316: begin
317:
318: open cur_database_items;

Line 701: ff_database_items fdi

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

Line 830: ff_database_items fdi

826:
827: cursor cur_archive_value is
828: select fai.value
829: from ff_archive_items fai,
830: ff_database_items fdi
831: where fdi.user_name = p_user_name
832: and fdi.user_entity_id = fai.user_entity_id
833: and fai.context1 = p_assactid;
834: