[Home] [Help]
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;
1249: from hr_positions_f
1250: where position_id = p_position_id
1251: and p_effective_date between effective_start_date and nvl (effective_end_date, p_effective_date);
1252:
1253: l_balance_name pay_balance_types.balance_name%type;
1254: rl_primary_address csr_primary_address%rowtype;
1255: l_postal_code per_addresses.postal_code%type;
1256: l_country per_addresses.country%type;
1257: rl_permanent_address csr_permanent_address%rowtype;
1808: cursor csr_get_defined_balance_id (
1809: csr_v_balance_name ff_database_items.user_name%type
1810: ) is
1811: select defined_balance_id
1812: from pay_balance_types pbt, pay_balance_dimensions pbd, pay_defined_balances pdb
1813: where pbt.balance_name = csr_v_balance_name
1814: and nvl(pbt.business_group_id,g_business_group_id) = g_business_group_id
1815: and pbt.balance_type_id = pdb.balance_type_id
1816: and pbd.database_item_suffix = p_database_item_suffix --'_PER_YTD'