DBA Data[Home] [Help]

APPS.PAY_KR_REPORT_PKG dependencies on FF_USER_ENTITIES

Line 19: type user_entity_id_tbl is table of ff_user_entities.user_entity_id%type index by binary_integer;

15: type value_tbl is table of ff_archive_items.value%type index by binary_integer;
16: type balance_name_tbl is table of pay_balance_types.balance_name%type index by binary_integer;
17: type dimension_name_tbl is table of pay_balance_dimensions.dimension_name%type index by binary_integer;
18: type defined_balance_id_tbl is table of pay_defined_balances.defined_balance_id%type index by binary_integer;
19: type user_entity_id_tbl is table of ff_user_entities.user_entity_id%type index by binary_integer;
20: type user_entity_name_tbl is table of ff_user_entities.user_entity_name%type index by binary_integer;
21: type user_name_tbl is table of ff_database_items.user_name%type index by binary_integer;
22: /*
23: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;

Line 20: type user_entity_name_tbl is table of ff_user_entities.user_entity_name%type index by binary_integer;

16: type balance_name_tbl is table of pay_balance_types.balance_name%type index by binary_integer;
17: type dimension_name_tbl is table of pay_balance_dimensions.dimension_name%type index by binary_integer;
18: type defined_balance_id_tbl is table of pay_defined_balances.defined_balance_id%type index by binary_integer;
19: type user_entity_id_tbl is table of ff_user_entities.user_entity_id%type index by binary_integer;
20: type user_entity_name_tbl is table of ff_user_entities.user_entity_name%type index by binary_integer;
21: type user_name_tbl is table of ff_database_items.user_name%type index by binary_integer;
22: /*
23: type user_entity_id_tbl is table of ff_archive_items.user_entity_id%type index by binary_integer;
24: type archive_item_rec is record(

Line 83: from ff_user_entities fue,

79: pbt.balance_name balance_name,
80: pbd.dimension_name dimension_name,
81: pdb.defined_balance_id defined_balance_id,
82: fue.user_entity_id user_entity_id
83: from ff_user_entities fue,
84: pay_balance_dimensions pbd,
85: pay_defined_balances pdb,
86: pay_balance_types pbt
87: where decode(pbt.business_group_id, null, g_business_group_id, pbt.business_group_id) = g_business_group_id

Line 131: ff_user_entities xfue,

127: xfue.user_entity_id xuser_entity_id,
128: xfue.user_entity_name xuser_entity_name,
129: fdi.user_name user_name
130: from ff_database_items fdi,
131: ff_user_entities xfue,
132: ff_user_entities fue
133: where nvl(fue.business_group_id,g_business_group_id) = g_business_group_id
134: and nvl(fue.legislation_code,g_legislation_code) = g_legislation_code
135: and xfue.user_entity_name = 'A_'||fue.user_entity_name

Line 132: ff_user_entities fue

128: xfue.user_entity_name xuser_entity_name,
129: fdi.user_name user_name
130: from ff_database_items fdi,
131: ff_user_entities xfue,
132: ff_user_entities fue
133: where nvl(fue.business_group_id,g_business_group_id) = g_business_group_id
134: and nvl(fue.legislation_code,g_legislation_code) = g_legislation_code
135: and xfue.user_entity_name = 'A_'||fue.user_entity_name
136: and xfue.user_entity_name like 'A_%'

Line 234: l_user_entity_id ff_user_entities.user_entity_id%type;

230: p_business_group_id in number) return number
231: --------------------------------------------------------------------------------
232: is
233: --
234: l_user_entity_id ff_user_entities.user_entity_id%type;
235: l_index binary_integer;
236: l_found boolean := FALSE;
237: --
238: cursor csr_user_entity_id

Line 241: from ff_user_entities fue,

237: --
238: cursor csr_user_entity_id
239: is
240: select fue.user_entity_id user_entity_id
241: from ff_user_entities fue,
242: pay_balance_dimensions pbd,
243: pay_balance_types pbt,
244: pay_defined_balances pdb
245: where pdb.defined_balance_id = p_defined_balance_id

Line 302: l_user_entity_id ff_user_entities.user_entity_id%type;

298: p_business_group_id in number) return number
299: --------------------------------------------------------------------------------
300: is
301: --
302: l_user_entity_id ff_user_entities.user_entity_id%type;
303: l_index binary_integer;
304: l_found boolean := FALSE;
305: --
306: cursor csr_user_entity_id

Line 309: from ff_user_entities fue,

305: --
306: cursor csr_user_entity_id
307: is
308: select fue.user_entity_id user_entity_id
309: from ff_user_entities fue,
310: ff_database_items fdi
311: where fdi.user_name = p_user_name
312: and fue.user_entity_id = fdi.user_entity_id
313: and nvl(fue.business_group_id,g_business_group_id) = g_business_group_id

Line 360: l_xuser_entity_id ff_user_entities.user_entity_id%type;

356: p_business_group_id in number) return number
357: --------------------------------------------------------------------------------
358: is
359: --
360: l_xuser_entity_id ff_user_entities.user_entity_id%type;
361: l_index binary_integer;
362: l_found boolean := FALSE;
363: --
364: cursor csr_xuser_entity_id

Line 367: from ff_user_entities xfue,

363: --
364: cursor csr_xuser_entity_id
365: is
366: select xfue.user_entity_id xuser_entity_id
367: from ff_user_entities xfue,
368: ff_user_entities fue
369: where fue.user_entity_id = p_user_entity_id
370: and xfue.user_entity_name = 'A_'||fue.user_entity_name
371: and nvl(xfue.business_group_id,g_business_group_id) = g_business_group_id

Line 368: ff_user_entities fue

364: cursor csr_xuser_entity_id
365: is
366: select xfue.user_entity_id xuser_entity_id
367: from ff_user_entities xfue,
368: ff_user_entities fue
369: where fue.user_entity_id = p_user_entity_id
370: and xfue.user_entity_name = 'A_'||fue.user_entity_name
371: and nvl(xfue.business_group_id,g_business_group_id) = g_business_group_id
372: and nvl(xfue.legislation_code,g_legislation_code) = g_legislation_code