APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on FF_DATABASE_ITEMS

Line 224: from ff_database_items fdi,

220: --
221:
222: cursor c_def_bal_id(cp_balance_name in varchar2) is
223: select creator_id
224: from ff_database_items fdi,
225: ff_user_entities fue
226: where fue.user_entity_id = fdi.user_entity_id
227: and fue.creator_type='B'
228: and fdi.user_name = cp_balance_name;

Line 448: from ff_database_items fdi,

444: roth_403b_balance_name varchar2(40) := 'ROTH_403B_AMOUNT_PER_GRE_YTD';
445:
446: cursor c_def_bal_id(cp_balance_name in varchar2) is
447: select creator_id
448: from ff_database_items fdi,
449: ff_user_entities fue
450: where fue.user_entity_id = fdi.user_entity_id
451: and fue.creator_type='B'
452: and fdi.user_name = cp_balance_name;

Line 505: from ff_database_items fdi,

501: p_tax_group IN VARCHAR2) is
502:
503: cursor c_def_bal_id(cp_balance_name in varchar2) is
504: select creator_id
505: from ff_database_items fdi,
506: ff_user_entities fue
507: where fue.user_entity_id = fdi.user_entity_id
508: and fue.creator_type='B'
509: and fdi.user_name = cp_balance_name;

Line 656: from ff_database_items fdi,

652: procedure populate_state_balance_list (p_tax_type IN VARCHAR2) is
653:
654: cursor c_def_bal_id(cp_balance_name in varchar2) is
655: select creator_id
656: from ff_database_items fdi,
657: ff_user_entities fue
658: where fue.user_entity_id = fdi.user_entity_id
659: and fue.creator_type='B'
660: and fdi.user_name = cp_balance_name;