APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_DATABASE_ITEMS

Line 672: ,p_data_type IN ff_database_items.data_type%TYPE)

668: FUNCTION compare_user_entity_value
669: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
670: ,p_value1 IN ff_archive_items.value%TYPE
671: ,p_value2 IN ff_archive_items.value%TYPE
672: ,p_data_type IN ff_database_items.data_type%TYPE)
673: RETURN VARCHAR2
674: IS
675:
676: l_procedure VARCHAR2(80);

Line 896: ff_database_items fdi

892: SELECT fai.value
893: ,fdi.data_type
894: FROM ff_archive_items fai,
895: ff_user_entities fue,
896: ff_database_items fdi
897: WHERE fai.context1 = c_assignment_action_id
898: AND fai.user_entity_id = fue.user_entity_id
899: AND fdi.user_entity_id = fue.user_entity_id
900: AND fue.user_entity_name = c_user_entity_name;

Line 907: l_data_type ff_database_items.data_type%TYPE;

903: l_procedure VARCHAR2(80);
904:
905: l_item_type VARCHAR2(20);
906: l_old_value ff_archive_items.value%TYPE;
907: l_data_type ff_database_items.data_type%TYPE;
908:
909: l_compare_flag VARCHAR2(2);
910: l_etp_cmn_flag VARCHAR2(2);
911:

Line 1365: ,ff_database_items dbi

1361: IS
1362: SELECT fue.user_entity_id
1363: ,dbi.data_type
1364: FROM ff_user_entities fue
1365: ,ff_database_items dbi
1366: WHERE user_entity_name = c_user_entity_name
1367: AND fue.user_entity_id = dbi.user_entity_id
1368: AND fue.legislation_code = 'AU';
1369: