APPS.PAY_KR_BEE_UPLOAD dependencies on PAY_USER_TABLES

Line 80: l_range_or_match pay_user_tables.range_or_match%type;

76: p_low_high_range in varchar2,
77: p_effective_date in date default null)
78: return varchar2 is
79: l_effective_date date;
80: l_range_or_match pay_user_tables.range_or_match%type;
81: l_table_id pay_user_tables.user_table_id%type;
82: l_value pay_user_column_instances_f.value%type;
83: l_row_low_range pay_user_rows_f.row_low_range_or_name%type;
84: l_row_high_range pay_user_rows_f.row_high_range%type;

Line 81: l_table_id pay_user_tables.user_table_id%type;

77: p_effective_date in date default null)
78: return varchar2 is
79: l_effective_date date;
80: l_range_or_match pay_user_tables.range_or_match%type;
81: l_table_id pay_user_tables.user_table_id%type;
82: l_value pay_user_column_instances_f.value%type;
83: l_row_low_range pay_user_rows_f.row_low_range_or_name%type;
84: l_row_high_range pay_user_rows_f.row_high_range%type;
85: l_leg_code varchar2(2);

Line 99: from pay_user_tables

95: where business_group_id = p_bus_group_id;
96:
97: cursor csr_chk_range_match is
98: select range_or_match, user_table_id
99: from pay_user_tables
100: where upper(user_table_name) = upper(p_table_name)
101: and nvl (business_group_id,
102: p_bus_group_id) = p_bus_group_id
103: and nvl(legislation_code, l_leg_code) = l_leg_code;

Line 110: , pay_user_tables TAB

106: select decode(upper(p_low_high_range),'H',R.row_high_range,R.row_low_range_or_name)
107: from pay_user_column_instances_f CINST
108: , pay_user_columns C
109: , pay_user_rows_f R
110: , pay_user_tables TAB
111: where TAB.user_table_id = l_table_id
112: and C.user_table_id = TAB.user_table_id
113: and nvl (C.business_group_id,
114: p_bus_group_id) = p_bus_group_id