APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_BALANCE_TYPES

Line 967: l_bal_name pay_balance_types.balance_name%TYPE;

963: p_tax_unit_id number) is
964: --
965: l_temp_over_limit number;
966: l_bal_feed_exists varchar2(1);
967: l_bal_name pay_balance_types.balance_name%TYPE;
968: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
969: l_bal_dimension varchar2(150) := 'Person within Government Reporting Entity Year to Date';
970: l_def_balance_id ff_user_entities.creator_id%TYPE;
971: l_value number;

Line 968: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

964: --
965: l_temp_over_limit number;
966: l_bal_feed_exists varchar2(1);
967: l_bal_name pay_balance_types.balance_name%TYPE;
968: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
969: l_bal_dimension varchar2(150) := 'Person within Government Reporting Entity Year to Date';
970: l_def_balance_id ff_user_entities.creator_id%TYPE;
971: l_value number;
972:

Line 978: from pay_balance_types bal

974: cursor csr_balance_type(cp_tax_type varchar2
975: , cp_bg_id number
976: ) is
977: select bal.balance_type_id, bal.balance_name
978: from pay_balance_types bal
979: where bal.balance_name like cp_tax_type
980: and bal.business_group_id = cp_bg_id
981: order by bal.balance_name DESC;
982: --