APPS.PAY_US_1099R_UDFS dependencies on FF_DATABASE_ITEMS

Line 370: l_entity_id ff_database_items.user_entity_id%type;

366: sp_out_9 OUT nocopy varchar2,
367: sp_out_10 OUT nocopy varchar2)
368: RETURN VARCHAR2 IS
369:
370: l_entity_id ff_database_items.user_entity_id%type;
371: l_archived_value ff_archive_items.value%type;
372: l_message varchar2(1000);
373: l_main_return varchar2(100);
374:

Line 376: p_user_name ff_database_items.user_name%type,

372: l_message varchar2(1000);
373: l_main_return varchar2(100);
374:
375: TYPE dbi_columns IS RECORD(
376: p_user_name ff_database_items.user_name%type,
377: p_archived_value ff_archive_items.value%type);
378:
379: dbi_rec dbi_columns;
380:

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

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

Line 389: FROM ff_database_items fdi,

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

Line 396: c_user_entity_id ff_database_items.user_entity_id%type,

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

Line 414: c_user_entity_id ff_database_items.user_entity_id%type,

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

Line 555: ff_database_items fdi

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

Line 1292: l_entity_id ff_database_items.user_entity_id%type;

1288: sp_out_9 IN OUT nocopy varchar2,
1289: sp_out_10 IN OUT nocopy varchar2)
1290: RETURN VARCHAR2 IS
1291:
1292: l_entity_id ff_database_items.user_entity_id%type;
1293: l_archived_value ff_archive_items.value%type;
1294: l_message varchar2(1000);
1295: l_main_return varchar2(100);
1296: l_payee_count number;