DBA Data[Home] [Help]

APPS.PAY_AC_UTILITY dependencies on PAY_BALANCE_TYPES

Line 134: from pay_balance_types

130: cursor get_bal_tp_id ( cp_balance_name VARCHAR2
131: , cp_bus_grp_id NUMBER
132: , cp_legislation_cd VARCHAR2 )is
133: select balance_type_id
134: from pay_balance_types
135: where balance_name = p_balance_name
136: and (( business_group_id = cp_bus_grp_id and
137: cp_legislation_cd is null ) or
138: ( legislation_code = cp_legislation_cd and

Line 174: from pay_balance_types_tl pbt

170: RETURN VARCHAR2 IS
171:
172: cursor csr_balance (cp_balance_type_id number) is
173: select balance_name, reporting_name
174: from pay_balance_types_tl pbt
175: where balance_type_id = cp_balance_type_id
176: and language = USERENV('LANG') ;
177: --
178: lv_balance_name VARCHAR2(240);