APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_USER_TABLES

Line 3020: l_range_or_match pay_user_tables.range_or_match%type;

3016: p_period_number in number,
3017: p_period_type in varchar2)
3018: return varchar2 is
3019: l_effective_date date;
3020: l_range_or_match pay_user_tables.range_or_match%type;
3021: l_table_id pay_user_tables.user_table_id%type;
3022: l_value pay_user_column_instances_f.value%type;
3023: ln_period_days number;
3024: begin

Line 3021: l_table_id pay_user_tables.user_table_id%type;

3017: p_period_type in varchar2)
3018: return varchar2 is
3019: l_effective_date date;
3020: l_range_or_match pay_user_tables.range_or_match%type;
3021: l_table_id pay_user_tables.user_table_id%type;
3022: l_value pay_user_column_instances_f.value%type;
3023: ln_period_days number;
3024: begin
3025: hr_utility_trace('p_bus_group_id: ' ||p_bus_group_id);

Line 3044: from pay_user_tables

3040: -- get the type of query to be performed, either range or match
3041: --
3042: select range_or_match, user_table_id
3043: into l_range_or_match, l_table_id
3044: from pay_user_tables
3045: where upper(user_table_name) = upper(p_table_name)
3046: and nvl (business_group_id,
3047: p_bus_group_id) = p_bus_group_id
3048: and nvl(legislation_code, 'MX') = 'MX';

Line 3067: from pay_user_tables TAB

3063: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
3064: ORDERED */
3065: CINST.value
3066: into l_value
3067: from pay_user_tables TAB
3068: , pay_user_columns C
3069: , pay_user_rows_f R
3070: , pay_user_column_instances_f CINST
3071: where TAB.user_table_id = l_table_id