470: cursor csr_balance (
471: p_balance_category_name varchar2
472: ) is
473: select pbt.balance_name
474: from pay_balance_types pbt, pay_balance_categories_f pbc
475: where pbc.legislation_code = 'FI'
476: and pbt.balance_category_id = pbc.balance_category_id
477: and pbt.business_group_id = g_business_group_id
478: and pbc.category_name = p_balance_category_name;
1219: cursor csr_balance (
1220: p_balance_category_name varchar2
1221: ) is
1222: select pbt.balance_name
1223: from pay_balance_types pbt, pay_balance_categories_f pbc
1224: where pbc.legislation_code = 'FI'
1225: and pbt.balance_category_id = pbc.balance_category_id
1226: and pbt.business_group_id = g_business_group_id
1227: and pbc.category_name = p_balance_category_name;