APPS.PAY_US_1099R_UDFS dependencies on FF_DATABASE_ITEMS

Line 374: l_entity_id ff_database_items.user_entity_id%type;

370: sp_out_9 OUT nocopy varchar2,
371: sp_out_10 OUT nocopy varchar2)
372: RETURN VARCHAR2 IS
373:
374: l_entity_id ff_database_items.user_entity_id%type;
375: l_archived_value ff_archive_items.value%type;
376: l_message varchar2(1000);
377: l_main_return varchar2(100);
378:

Line 380: p_user_name ff_database_items.user_name%type,

376: l_message varchar2(1000);
377: l_main_return varchar2(100);
378:
379: TYPE dbi_columns IS RECORD(
380: p_user_name ff_database_items.user_name%type,
381: p_archived_value ff_archive_items.value%type);
382:
383: dbi_rec dbi_columns;
384:

Line 391: (c_user_name ff_database_items.user_name%type) IS

387:
388: dbi_table dbi_infm;
389:
390: CURSOR get_user_entity_id
391: (c_user_name ff_database_items.user_name%type) IS
392: SELECT fdi.user_entity_id
393: FROM ff_database_items fdi,
394: ff_user_entities fue
395: WHERE fue.legislation_code = 'US'

Line 393: FROM ff_database_items fdi,

389:
390: CURSOR get_user_entity_id
391: (c_user_name ff_database_items.user_name%type) IS
392: SELECT fdi.user_entity_id
393: FROM ff_database_items fdi,
394: ff_user_entities fue
395: WHERE fue.legislation_code = 'US'
396: AND fue.user_entity_id = fdi.user_entity_id
397: AND fdi.user_name = c_user_name;

Line 400: c_user_entity_id ff_database_items.user_entity_id%type,

396: AND fue.user_entity_id = fdi.user_entity_id
397: AND fdi.user_name = c_user_name;
398:
399: CURSOR get_archived_values(
400: c_user_entity_id ff_database_items.user_entity_id%type,
401: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
402: c_tax_unit_id hr_organization_units.organization_id%type)
403: IS
404: SELECT target.value

Line 418: c_user_entity_id ff_database_items.user_entity_id%type,

414: and ltrim(rtrim(con2.context)) = to_char(c_tax_unit_id);
415: /*context of tax_unit_id */
416:
417: CURSOR get_archived_values_assignment(
418: c_user_entity_id ff_database_items.user_entity_id%type,
419: c_assignment_action_id pay_assignment_actions.assignment_action_id%type
420: )
421: IS
422: SELECT target.value

Line 559: ff_database_items fdi

555: ff_archive_item_contexts con2,
556: ff_contexts fc3,
557: ff_contexts fc2,
558: ff_archive_items target,
559: ff_database_items fdi
560: where fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
561: and target.user_entity_id = fdi.user_entity_id
562: and target.context1 = to_char(c_assignment_action_id)
563: /* context assignment action id */

Line 1316: l_entity_id ff_database_items.user_entity_id%type;

1312: sp_out_9 IN OUT nocopy varchar2,
1313: sp_out_10 IN OUT nocopy varchar2)
1314: RETURN VARCHAR2 IS
1315:
1316: l_entity_id ff_database_items.user_entity_id%type;
1317: l_archived_value ff_archive_items.value%type;
1318: l_message varchar2(1000);
1319: l_main_return varchar2(100);
1320: l_payee_count number;