APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 414: ff_database_items DI

410:
411: cursor csr_defined_balance is
412: select to_number(UE.creator_id)
413: from ff_user_entities UE,
414: ff_database_items DI
415: where DI.user_name = p_db_item_name
416: and UE.user_entity_id = DI.user_entity_id
417: and Ue.creator_type = 'B'
418: and UE.legislation_code = 'CA';

Line 1154: from ff_database_items fdi,

1150: begin
1151:
1152: select fdi.user_entity_id
1153: into l_user_entity_id
1154: from ff_database_items fdi,
1155: ff_user_entities fui
1156: where user_name = p_dbi_name
1157: and fdi.user_entity_id = fui.user_entity_id
1158: and fui.legislation_code = 'CA';

Line 1209: ff_database_items fdi1,

1205: cursor c_get_emp_t4box_data(cp_asg_act_id number,
1206: cp_jurisdiction varchar2) is
1207: SELECT fai1.context1,fdi1.user_entity_id,fai1.value
1208: FROM FF_ARCHIVE_ITEMS FAI1,
1209: ff_database_items fdi1,
1210: ff_archive_item_contexts faic,
1211: ff_contexts fc
1212: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
1213: and fai1.archive_item_id = faic.archive_item_id

Line 2436: ff_database_items fdi

2432: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2433: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2434: select fai.value
2435: from ff_archive_items fai,
2436: ff_database_items fdi
2437: where fdi.user_entity_id = fai.user_entity_id
2438: and fai.context1 = cp_assignment_action_id
2439: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
2440: