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_KR_REPORT_PKG dependencies on FF_DATABASE_ITEMS

Line 21: type user_name_tbl is table of ff_database_items.user_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(
25: user_entity_id user_entity_id_tbl,

Line 130: from ff_database_items fdi,

126: fue.user_entity_name user_entity_name,
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

Line 310: ff_database_items fdi

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
314: and nvl(fue.legislation_code,g_legislation_code) = g_legislation_code;

Line 822: l_user_name ff_database_items.user_name%type;

818: l_business_group_id number;
819: l_archive varchar2(1);
820: l_cache varchar2(1);
821: --
822: l_user_name ff_database_items.user_name%type;
823: l_payroll_id pay_payroll_actions.payroll_id%type;
824: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
825: l_assignment_id pay_assignment_actions.assignment_id%type;
826: l_date_earned pay_payroll_actions.date_earned%type;

Line 860: from ff_database_items fdi,

856: paa.assignment_id assignment_id,
857: ppa.date_earned date_earned,
858: paa.tax_unit_id tax_unit_id,
859: fdi.user_name user_name
860: from ff_database_items fdi,
861: pay_payroll_actions ppa,
862: pay_assignment_actions paa
863: where paa.assignment_action_id = g_assignment_action_id
864: and ppa.payroll_action_id = paa.payroll_action_id