APPS.PAY_CA_T4A_AMEND_MAG dependencies on FF_DATABASE_ITEMS

Line 23: FROM ff_database_items

19: l_legislative_parameters);
20:
21: SELECT user_entity_id
22: INTO l_tax_year_ue_id
23: FROM ff_database_items
24: WHERE user_name='CAEOY_TAXATION_YEAR';
25:
26:
27: SELECT user_entity_id

Line 29: FROM ff_database_items

25:
26:
27: SELECT user_entity_id
28: INTO l_person_id_ue_id
29: FROM ff_database_items
30: WHERE user_name='CAEOY_PERSON_ID';
31:
32:
33: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)

Line 167: FROM ff_database_items

163: AND user_entity_id = cp_uid_t4amend_flag;
164: -----
165: CURSOR c_get_ue_id(cp_user_name IN VARCHAR2) IS
166: SELECT user_entity_id
167: FROM ff_database_items
168: WHERE user_name = cp_user_name;
169: -----
170: CURSOR c_lockingactid_check (cp_locking_asg_act_id IN NUMBER) IS
171: SELECT assignment_action_id

Line 547: ff_database_items fdi

543: CURSOR cur_archive (b_context_id IN NUMBER,
544: b_user_name VARCHAR2) IS
545: SELECT fai.value
546: FROM ff_archive_items fai,
547: ff_database_items fdi
548: WHERE fai.user_entity_id = fdi.user_entity_id
549: AND fai.context1 = b_context_id
550: AND fdi.user_name = b_user_name;
551: