APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_DATABASE_ITEMS

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

1098: FUNCTION compare_user_entity_value
1099: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
1100: ,p_value1 IN ff_archive_items.value%TYPE
1101: ,p_value2 IN ff_archive_items.value%TYPE
1102: ,p_data_type IN ff_database_items.data_type%TYPE)
1103: RETURN VARCHAR2
1104: IS
1105:
1106: l_procedure VARCHAR2(80);

Line 1329: ff_database_items fdi

1325: SELECT fai.value
1326: ,fdi.data_type
1327: FROM ff_archive_items fai,
1328: ff_user_entities fue,
1329: ff_database_items fdi
1330: WHERE fai.context1 = c_assignment_action_id
1331: AND fai.user_entity_id = fue.user_entity_id
1332: AND fdi.user_entity_id = fue.user_entity_id
1333: AND fue.user_entity_name = c_user_entity_name;

Line 1340: l_data_type ff_database_items.data_type%TYPE;

1336: l_procedure VARCHAR2(80);
1337:
1338: l_item_type VARCHAR2(20);
1339: l_old_value ff_archive_items.value%TYPE;
1340: l_data_type ff_database_items.data_type%TYPE;
1341:
1342: l_compare_flag VARCHAR2(2);
1343: l_etp_cmn_flag VARCHAR2(2);
1344:

Line 1350: ff_database_items fdi

1346: CURSOR csr_data_type(c_user_entity_name VARCHAR2)
1347: IS
1348: SELECT fdi.data_type
1349: FROM ff_user_entities fue,
1350: ff_database_items fdi
1351: WHERE fdi.user_entity_id = fue.user_entity_id
1352: AND fue.user_entity_name = c_user_entity_name;
1353:
1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;

Line 2079: ,ff_database_items dbi

2075: IS
2076: SELECT fue.user_entity_id
2077: ,dbi.data_type
2078: FROM ff_user_entities fue
2079: ,ff_database_items dbi
2080: WHERE user_entity_name = c_user_entity_name
2081: AND fue.user_entity_id = dbi.user_entity_id
2082: AND fue.legislation_code = 'AU';
2083: