eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE dependencies on FF_USER_ENTITIES

Line 45: ( balance_id ff_user_entities.user_entity_id%type,

41: --------------------------------------------------------------------------------------------------------
42: -- Bug# 3501927 A8A Balance store rec
43: --------------------------------------------------------------------------------------------------------
44: type ytd_a8a_balance_store_rec is record
45: ( balance_id ff_user_entities.user_entity_id%type,
46: balance_value number );
47: type ytd_a8a_balance_tab is table of ytd_a8a_balance_store_rec index by binary_integer;
48: ytd_a8a_balance_rec ytd_a8a_balance_tab;
49: -- Bug# 3933332

Line 378: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

374: -----------------------------------------------------------------------------------------------------
375: -- Bug: 3118540 - This function is called from the report PYSG8SAD.rdf - 'IR8S Ad Hoc Printed Report'
376: -----------------------------------------------------------------------------------------------------
377: function get_archive_value
378: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
379: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type) return varchar2
380: is
381: cursor csr_get_value( p_user_entity_name varchar2,
382: p_assignment_action_id number ) is

Line 385: ff_user_entities fue

381: cursor csr_get_value( p_user_entity_name varchar2,
382: p_assignment_action_id number ) is
383: select fai.value
384: from ff_archive_items fai,
385: ff_user_entities fue
386: where fai.context1 = p_assignment_action_id
387: and fai.user_entity_id = fue.user_entity_id
388: and fue.user_entity_name = p_user_entity_name;
389: --

Line 624: from ff_user_entities fue,

620: --
621: cursor ytd_A8A_balances is
622: select fue.user_entity_id,
623: pdb.defined_balance_id def_bal_id
624: from ff_user_entities fue,
625: pay_balance_types pbt,
626: pay_defined_balances pdb,
627: pay_balance_dimensions pbd
628: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'

Line 1097: type t_user_entity_tab is table of ff_user_entities.user_entity_id%TYPE index by binary_integer;

1093: --
1094: type t_date_earned_tab is table of varchar2(30) index by binary_integer;
1095: t_date_earned t_date_earned_tab;
1096: --
1097: type t_user_entity_tab is table of ff_user_entities.user_entity_id%TYPE index by binary_integer;
1098: t_user_entity_id t_user_entity_tab;
1099: --
1100: ---------------------------------------------------------------------------------------------------
1101: -- This ytd_balances cursor only gets the defined_balance_id and user_entity_id

Line 1108: from ff_user_entities fue,

1104: ---------------------------------------------------------------------------------------------------
1105: cursor ytd_balances is
1106: select fue.user_entity_id,
1107: pdb.defined_balance_id def_bal_id
1108: from ff_user_entities fue,
1109: pay_balance_types pbt,
1110: pay_defined_balances pdb,
1111: pay_balance_dimensions pbd
1112: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'

Line 1195: from ff_user_entities fue,

1191: cursor month_balances
1192: is
1193: select fue.user_entity_id,
1194: pdb.defined_balance_id def_bal_id
1195: from ff_user_entities fue,
1196: pay_balance_types pbt,
1197: pay_defined_balances pdb,
1198: pay_balance_dimensions pbd
1199: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'

Line 1223: ( balance_id ff_user_entities.user_entity_id%type,

1219: -- Balance Store Record
1220: ---------------------------------------------------------------------------------------------------
1221: --
1222: type ytd_balance_store_rec is record
1223: ( balance_id ff_user_entities.user_entity_id%type,
1224: balance_value number );
1225: type ytd_balance_tab is table of ytd_balance_store_rec index by binary_integer;
1226: ytd_balance_rec ytd_balance_tab;
1227: --

Line 1229: ( balance_id ff_user_entities.user_entity_id%type,

1225: type ytd_balance_tab is table of ytd_balance_store_rec index by binary_integer;
1226: ytd_balance_rec ytd_balance_tab;
1227: --
1228: type mtd_balance_store_rec is record
1229: ( balance_id ff_user_entities.user_entity_id%type,
1230: balance_value number,
1231: date_earned varchar2(6),
1232: date_earned_archive varchar2(30),
1233: person_id number,

Line 4464: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

4460: ---------------------------------------------------------------------------
4461: -- Calls the archive utility to actually perform the archive of the item.
4462: ---------------------------------------------------------------------------
4463: procedure archive_item
4464: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4465: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4466: p_archive_value in ff_archive_items.value%type )
4467: is
4468: --

Line 4469: v_user_entity_id ff_user_entities.user_entity_id%type;

4465: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4466: p_archive_value in ff_archive_items.value%type )
4467: is
4468: --
4469: v_user_entity_id ff_user_entities.user_entity_id%type;
4470: v_archive_item_id ff_archive_items.archive_item_id%type;
4471: v_object_version_number ff_archive_items.object_version_number%type;
4472: v_some_warning boolean;
4473: ---------------------------------------------------------------------------

Line 4477: ( c_user_entity_name ff_user_entities.user_entity_name%type )

4473: ---------------------------------------------------------------------------
4474: -- Cursor User_Entity_ID
4475: ---------------------------------------------------------------------------
4476: cursor user_entity_id
4477: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4478: is
4479: select user_entity_id
4480: from ff_user_entities
4481: where user_entity_name = c_user_entity_name;

Line 4480: from ff_user_entities

4476: cursor user_entity_id
4477: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4478: is
4479: select user_entity_id
4480: from ff_user_entities
4481: where user_entity_name = c_user_entity_name;
4482: --
4483: begin
4484: if g_debug then

Line 4515: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

4511: -- Calls the archive utility to actually perform the archive of the item with
4512: -- one another context
4513: -----------------------------------------------------------------------------
4514: procedure archive_item_2
4515: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4517: p_archive_value in ff_archive_items.value%type,
4518: p_context_value2 in ff_archive_item_contexts.context%type )
4519: is

Line 4521: v_user_entity_id ff_user_entities.user_entity_id%type;

4517: p_archive_value in ff_archive_items.value%type,
4518: p_context_value2 in ff_archive_item_contexts.context%type )
4519: is
4520: --
4521: v_user_entity_id ff_user_entities.user_entity_id%type;
4522: v_archive_item_id ff_archive_items.archive_item_id%type;
4523: v_object_version_number ff_archive_items.object_version_number%type;
4524: v_some_warning boolean;
4525: ---------------------------------------------------------------------------

Line 4529: ( c_user_entity_name ff_user_entities.user_entity_name%type )

4525: ---------------------------------------------------------------------------
4526: -- Cursor User_Entity_ID
4527: ---------------------------------------------------------------------------
4528: cursor user_entity_id
4529: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4530: is
4531: select user_entity_id
4532: from ff_user_entities
4533: where user_entity_name = c_user_entity_name;

Line 4532: from ff_user_entities

4528: cursor user_entity_id
4529: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4530: is
4531: select user_entity_id
4532: from ff_user_entities
4533: where user_entity_name = c_user_entity_name;
4534: --
4535: begin
4536: if g_debug then

Line 4569: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

4565: -- Calls the archive utility to actually perform the archive of the item with
4566: -- one another context
4567: -----------------------------------------------------------------------------
4568: procedure archive_item_3
4569: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
4570: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
4571: p_archive_value in ff_archive_items.value%type,
4572: p_context_value2 in ff_archive_item_contexts.context%type,
4573: p_context_value3 in ff_archive_item_contexts.context%type )

Line 4576: v_user_entity_id ff_user_entities.user_entity_id%type;

4572: p_context_value2 in ff_archive_item_contexts.context%type,
4573: p_context_value3 in ff_archive_item_contexts.context%type )
4574: is
4575: --
4576: v_user_entity_id ff_user_entities.user_entity_id%type;
4577: v_archive_item_id ff_archive_items.archive_item_id%type;
4578: v_object_version_number ff_archive_items.object_version_number%type;
4579: v_some_warning boolean;
4580: ---------------------------------------------------------------------------

Line 4584: ( c_user_entity_name ff_user_entities.user_entity_name%type )

4580: ---------------------------------------------------------------------------
4581: -- Cursor User_Entity_ID
4582: ---------------------------------------------------------------------------
4583: cursor user_entity_id
4584: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4585: is
4586: select user_entity_id
4587: from ff_user_entities
4588: where user_entity_name = c_user_entity_name;

Line 4587: from ff_user_entities

4583: cursor user_entity_id
4584: ( c_user_entity_name ff_user_entities.user_entity_name%type )
4585: is
4586: select user_entity_id
4587: from ff_user_entities
4588: where user_entity_name = c_user_entity_name;
4589: --
4590: begin
4591: if g_debug then