APPS.PAY_CA_EOY_ARCHIVE dependencies on FF_DATABASE_ITEMS

Line 347: ff_database_items DI

343:
344: cursor csr_defined_balance is
345: select to_number(UE.creator_id)
346: from ff_user_entities UE,
347: ff_database_items DI
348: where DI.user_name = p_db_item_name
349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'
351: and UE.legislation_code = 'CA';

Line 987: from ff_database_items fdi,

983: begin
984:
985: select fdi.user_entity_id
986: into l_user_entity_id
987: from ff_database_items fdi,
988: ff_user_entities fui
989: where user_name = p_dbi_name
990: and fdi.user_entity_id = fui.user_entity_id
991: and fui.legislation_code = 'CA';

Line 1042: ff_database_items fdi1,

1038: cursor c_get_emp_t4box_data(cp_asg_act_id number,
1039: cp_jurisdiction varchar2) is
1040: SELECT fai1.context1,fdi1.user_entity_id,fai1.value
1041: FROM FF_ARCHIVE_ITEMS FAI1,
1042: ff_database_items fdi1,
1043: ff_archive_item_contexts faic,
1044: ff_contexts fc
1045: WHERE FAI1.USER_ENTITY_ID = fdi1.user_entity_id
1046: and fai1.archive_item_id = faic.archive_item_id

Line 2147: ff_database_items fdi

2143: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2144: CURSOR c_get_fapp_prov_emp(cp_assignment_action_id number) IS
2145: select fai.value
2146: from ff_archive_items fai,
2147: ff_database_items fdi
2148: where fdi.user_entity_id = fai.user_entity_id
2149: and fai.context1 = cp_assignment_action_id
2150: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
2151: