APPS.PAY_NZ_EMS_TAX_RATE dependencies on PAY_DEFINED_BALANCES

Line 82: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

78: ,P_DATE IN DATE)
79: RETURN NUMBER
80: IS
81:
82: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
83: l_bal_value NUMBER := 0;
84:
85: CURSOR csr_get_id
86: IS

Line 88: from pay_defined_balances

84:
85: CURSOR csr_get_id
86: IS
87: select defined_balance_id
88: from pay_defined_balances
89: where balance_type_id = ( select balance_type_id
90: from pay_balance_types
91: where legislation_code = 'NZ'
92: and balance_name = P_BAL_NAME