APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on FF_USER_ENTITIES

Line 150: (balance_id ff_user_entities.creator_id%TYPE,

146: g_inserted_asg_action_id number;
147: l_ppa_finder varchar2(240);
148: p_insert_done_flag varchar2(1):= 'N';
149: TYPE t_rec_bal IS RECORD
150: (balance_id ff_user_entities.creator_id%TYPE,
151: balance_name varchar2(1000),
152: tax_type varchar2(50)
153: );
154:

Line 209: ln_defined_bal_id ff_user_entities.creator_id%TYPE;

205: ln_balance_value number := 0;
206: ln_catchup_balance_value number := 0;
207: -- lv_tax_group hr_organization_information.org_information5%TYPE ;
208: lv_tg_balance_name varchar2(1000);
209: ln_defined_bal_id ff_user_entities.creator_id%TYPE;
210: lv_bal_flag varchar2(30) := ' ';
211: --
212: -- #2664340
213: lv_balance_name varchar2(1000);

Line 218: ln_catchup_defined_bal_id ff_user_entities.creator_id%TYPE;

214:
215: l_catchup_bal_name varchar2(50);
216: l_catchup_bal_id number;
217: l_catchup_count number :=1;
218: ln_catchup_defined_bal_id ff_user_entities.creator_id%TYPE;
219:
220: --
221:
222: cursor c_def_bal_id(cp_balance_name in varchar2) is

Line 225: ff_user_entities fue

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;
229: --

Line 449: ff_user_entities fue

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;
453:

Line 506: ff_user_entities fue

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;
510:

Line 657: ff_user_entities fue

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;
661:

Line 970: l_def_balance_id ff_user_entities.creator_id%TYPE;

966: l_bal_feed_exists varchar2(1);
967: l_bal_name pay_balance_types.balance_name%TYPE;
968: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
969: l_bal_dimension varchar2(150) := 'Person within Government Reporting Entity Year to Date';
970: l_def_balance_id ff_user_entities.creator_id%TYPE;
971: l_value number;
972:
973: --
974: cursor csr_balance_type(cp_tax_type varchar2