APPS.PAY_AU_PAYMENT_SUMMARY dependencies on FF_USER_ENTITIES

Line 2047: p_user_entity_name in ff_user_entities.user_entity_name%type,

2043:
2044:
2045: procedure create_extract_archive_details
2046: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2047: p_user_entity_name in ff_user_entities.user_entity_name%type,
2048: p_value in out nocopy ff_archive_items.value%type) is
2049:
2050:
2051:

Line 2056: from ff_user_entities fue,

2052: cursor get_user_entity_id(c_user_entity_name in varchar2)
2053: is
2054: select fue.user_entity_id,
2055: dbi.data_type
2056: from ff_user_entities fue,
2057: ff_database_items dbi
2058: where user_entity_name =c_user_entity_name
2059: and fue.user_entity_id =dbi.user_entity_id;
2060:

Line 2062: v_user_entity_id ff_user_entities.user_entity_id%type;

2058: where user_entity_name =c_user_entity_name
2059: and fue.user_entity_id =dbi.user_entity_id;
2060:
2061: v_full_name per_all_people_f.full_name%type;
2062: v_user_entity_id ff_user_entities.user_entity_id%type;
2063: v_archive_item_id ff_archive_items.archive_item_id%type;
2064: v_data_type ff_database_items.data_type%type;
2065: v_object_version_number ff_archive_items.object_version_number%type;
2066: v_some_warning boolean;

Line 9327: function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,

9323: -- called from validation report and payment summary report
9324: --------------------------------------------------------------------+
9325:
9326:
9327: function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,
9328: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
9329: return varchar2 is
9330:
9331:

Line 9338: ff_user_entities fue

9334: cursor csr_get_value(p_user_entity_name varchar2,
9335: p_assignment_action_id number) is
9336: select fai.value
9337: from ff_archive_items fai,
9338: ff_user_entities fue
9339: where fai.context1 = p_assignment_action_id
9340: and fai.user_entity_id = fue.user_entity_id
9341: and fue.user_entity_name = p_user_entity_name;
9342: