APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 277: ff_database_items DI

273:
274: cursor csr_defined_balance is
275: select to_number(UE.creator_id)
276: from ff_user_entities UE,
277: ff_database_items DI
278: where DI.user_name = p_db_item_name
279: and UE.user_entity_id = DI.user_entity_id
280: and Ue.creator_type = 'B'
281: and UE.legislation_code = 'CA';

Line 835: from ff_database_items fdi,

831: hr_utility.trace('getting the user_entity_id for '
832: || p_dbi_name);
833: select fdi.user_entity_id
834: into l_user_entity_id
835: from ff_database_items fdi,
836: ff_user_entities fui
837: where user_name = p_dbi_name
838: and fdi.user_entity_id = fui.user_entity_id
839: and fui.legislation_code = 'CA';

Line 866: from ff_database_items

862: begin
863:
864: select user_entity_id
865: into l_user_entity_id
866: from ff_database_items
867: where user_name = p_dbi_name;
868:
869: return l_user_entity_id;
870:

Line 913: ff_database_items fdi1

909: SELECT fai1.context1,
910: fdi1.user_entity_id,
911: fai1.value
912: FROM ff_archive_items fai1,
913: ff_database_items fdi1
914: WHERE fai1.user_entity_id = fdi1.user_entity_id
915: AND fai1.context1 = cp_asg_act_id
916: AND fdi1.user_name <> 'CAEOY_T4A_AMENDMENT_FLAG'
917: order by fdi1.user_name;