APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 355: ff_database_items DI

351:
352: cursor csr_defined_balance is
353: select to_number(UE.creator_id)
354: from ff_user_entities UE,
355: ff_database_items DI
356: where DI.user_name = p_db_item_name
357: and UE.user_entity_id = DI.user_entity_id
358: and Ue.creator_type = 'B'
359: and UE.legislation_code = 'CA';

Line 1012: from ff_database_items fdi,

1008: hr_utility.trace('getting the user_entity_id for '
1009: || p_dbi_name);
1010: select fdi.user_entity_id
1011: into l_user_entity_id
1012: from ff_database_items fdi,
1013: ff_user_entities fui
1014: where user_name = p_dbi_name
1015: and fdi.user_entity_id = fui.user_entity_id
1016: and fui.legislation_code = 'CA';

Line 1043: from ff_database_items

1039: begin
1040:
1041: select user_entity_id
1042: into l_user_entity_id
1043: from ff_database_items
1044: where user_name = p_dbi_name;
1045:
1046: return l_user_entity_id;
1047:

Line 1090: ff_database_items fdi1

1086: SELECT fai1.context1,
1087: fdi1.user_entity_id,
1088: fai1.value
1089: FROM ff_archive_items fai1,
1090: ff_database_items fdi1
1091: WHERE fai1.user_entity_id = fdi1.user_entity_id
1092: AND fai1.context1 = cp_asg_act_id
1093: AND fdi1.user_name <> 'CAEOY_T4A_AMENDMENT_FLAG'
1094: order by fdi1.user_name;