APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2820: , pay_user_column_instances_f CINST

2816: SELECT fnd_number.canonical_to_number(CINST.value)* fnd_number.canonical_to_number(p_proration_fac)
2817: FROM pay_user_tables TAB
2818: , pay_user_columns C
2819: , pay_user_rows_f R
2820: , pay_user_column_instances_f CINST
2821: WHERE TAB.user_table_id = p_table_id
2822: AND C.user_table_id = TAB.user_table_id
2823: AND nvl (C.business_group_id,
2824: p_business_group_id) = p_business_group_id

Line 4343: , pay_user_column_instances_f CINST

4339: CINST.value
4340: from pay_user_tables TAB
4341: , pay_user_columns C
4342: , pay_user_rows_f R
4343: , pay_user_column_instances_f CINST
4344: where TAB.user_table_id = p_table_id
4345: and C.user_table_id = TAB.user_table_id
4346: and nvl (C.business_group_id,
4347: p_bus_grp_id) = p_bus_grp_id

Line 4369: l_table_value pay_user_column_instances_f.value%type;

4365: and nvl (CINST.legislation_code,
4366: 'MX') = 'MX'
4367: order by R.display_sequence asc;
4368:
4369: l_table_value pay_user_column_instances_f.value%type;
4370: i number;
4371: table_count number;
4372:
4373: -- Record to store prorated table data for Bug 14094610

Line 4377: ,row_value pay_user_column_instances_f.value%type);

4373: -- Record to store prorated table data for Bug 14094610
4374: TYPE pro_table_rec IS RECORD
4375: (low_range number
4376: ,high_range number
4377: ,row_value pay_user_column_instances_f.value%type);
4378:
4379: -- Declare table for the record pro_table_rec for Bug 14094610
4380: TYPE pro_table_val IS TABLE OF pro_table_rec INDEX BY BINARY_INTEGER;
4381:

Line 4474: l_value pay_user_column_instances_f.value%type;

4470: return varchar2 is
4471: l_effective_date date;
4472: l_range_or_match pay_user_tables.range_or_match%type;
4473: l_table_id pay_user_tables.user_table_id%type;
4474: l_value pay_user_column_instances_f.value%type;
4475: ln_period_days number;
4476: begin
4477: hr_utility_trace('p_bus_group_id: ' ||p_bus_group_id);
4478: hr_utility_trace('p_table_name: ' ||p_table_name);

Line 4546: , pay_user_column_instances_f CINST

4542: into l_value
4543: from pay_user_tables TAB
4544: , pay_user_columns C
4545: , pay_user_rows_f R
4546: , pay_user_column_instances_f CINST
4547: where TAB.user_table_id = l_table_id
4548: and C.user_table_id = TAB.user_table_id
4549: and nvl (C.business_group_id,
4550: p_bus_group_id) = p_bus_group_id