APPS.PAY_PL_UTILITY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 242: pay_user_column_instances_f ci,

238: p_spouse_or_child_flag IN VARCHAR2,
239: p_tax_percentage OUT NOCOPY NUMBER) RETURN NUMBER is
240:
241: cursor csr_level is select ci.value from
242: pay_user_column_instances_f ci,
243: pay_user_columns c,
244: pay_user_rows_f r,
245: pay_user_tables t
246: where r.user_table_id = t.user_table_id

Line 258: pay_user_column_instances_f ci,

254: and round(p_taxable_base,2) between r.row_low_range_or_name and r.row_high_range;
255:
256: cursor csr_rate_of_tax(p_level number) is select ci.value
257: from
258: pay_user_column_instances_f ci,
259: pay_user_column_instances_f cilvl,
260: pay_user_rows_f r,
261: pay_user_rows_f rlvl,
262: pay_user_columns c,

Line 259: pay_user_column_instances_f cilvl,

255:
256: cursor csr_rate_of_tax(p_level number) is select ci.value
257: from
258: pay_user_column_instances_f ci,
259: pay_user_column_instances_f cilvl,
260: pay_user_rows_f r,
261: pay_user_rows_f rlvl,
262: pay_user_columns c,
263: pay_user_columns clvl,

Line 280: l_row_level pay_user_column_instances_f.value%type;

276: and r.row_low_range_or_name = rlvl.row_low_range_or_name
277: and p_date_earned between ci.effective_start_date and ci.effective_end_date
278: and p_date_earned between cilvl.effective_start_date and cilvl.effective_end_date
279: and cilvl.value = p_level;
280: l_row_level pay_user_column_instances_f.value%type;
281:
282: BEGIN
283: open csr_level;
284: fetch csr_level into l_row_level;