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_FR_GENERAL dependencies on PAY_USER_COLUMN_INSTANCES

Line 230: l_base_type pay_user_Column_instances_f.value%type;

226: function get_base_name(p_business_group_id in number
227: ,p_group_code in varchar2)
228: return varchar2
229: is
230: l_base_type pay_user_Column_instances_f.value%type;
231: l_proc varchar2(72) := g_package||'.get_base_name';
232: --
233: begin
234: --

Line 263: l_base_type pay_user_Column_instances_f.value%type;

259: ,p_cu_id in number)
260: return varchar2
261: is
262:
263: l_base_type pay_user_Column_instances_f.value%type;
264: l_group_code pay_fr_contribution_usages.group_code%TYPE;
265: l_proc varchar2(72) := g_package||'.get_base_name_cu';
266: --
267: begin

Line 459: l_base_name pay_user_Column_instances_f.value%type;

455: l_contribution_usage_id number;
456: l_contribution_code varchar2(30);
457: l_contribution_value number;
458: l_contribution_type varchar2(10);
459: l_base_name pay_user_Column_instances_f.value%type;
460: l_code_rate_id number;
461: l_rate_category varchar2(1);
462: l_element_name pay_fr_contribution_usages.element_name%type;
463:

Line 1469: l_base_name pay_user_Column_instances_f.value%type;

1465: l_contribution_usage_id number;
1466: l_contribution_code varchar2(30);
1467: l_contribution_value number;
1468: l_contribution_type varchar2(10);
1469: l_base_name pay_user_Column_instances_f.value%type;
1470: l_code_rate_id number;
1471: l_rate_category varchar2(1);
1472: l_element_name pay_fr_contribution_usages.element_name%type;
1473:

Line 2865: l_value pay_user_column_instances_f.value%type;

2861: p_user_column_instance_id out NOCOPY number )
2862: return number is
2863: l_effective_date date;
2864: l_table_id pay_user_tables.user_table_id%type;
2865: l_value pay_user_column_instances_f.value%type;
2866: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%type;
2867: l_user_row_id pay_user_column_instances_f.user_row_id%type;
2868: l_proc varchar2(72) := g_package||'.get_table_rate';
2869:

Line 2866: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%type;

2862: return number is
2863: l_effective_date date;
2864: l_table_id pay_user_tables.user_table_id%type;
2865: l_value pay_user_column_instances_f.value%type;
2866: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%type;
2867: l_user_row_id pay_user_column_instances_f.user_row_id%type;
2868: l_proc varchar2(72) := g_package||'.get_table_rate';
2869:
2870:

Line 2867: l_user_row_id pay_user_column_instances_f.user_row_id%type;

2863: l_effective_date date;
2864: l_table_id pay_user_tables.user_table_id%type;
2865: l_value pay_user_column_instances_f.value%type;
2866: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%type;
2867: l_user_row_id pay_user_column_instances_f.user_row_id%type;
2868: l_proc varchar2(72) := g_package||'.get_table_rate';
2869:
2870:
2871: --

Line 2877: from pay_user_column_instances CINST

2873:
2874: select CINST.value,
2875: CINST.user_column_instance_id,
2876: CINST.user_row_id
2877: from pay_user_column_instances CINST
2878: , pay_user_columns C
2879: , pay_user_rows R
2880: , pay_user_tables TAB
2881: where TAB.user_table_name = p_table_name