DBA Data[Home] [Help]

APPS.PAY_IP_RUN_BALANCE_UPGRADE dependencies on PAY_BALANCE_DIMENSIONS

Line 129: pay_balance_dimensions pbd

125: ,cp_bal_dim in varchar2) is
126: select pdb.defined_balance_id
127: from pay_defined_balances pdb,
128: pay_balance_types pbt,
129: pay_balance_dimensions pbd
130: where pbt.balance_type_id = cp_bal_type_id
131: and pbd.database_item_suffix = cp_bal_dim
132: and pbd.legislation_code = cp_legislation_code
133: and pdb.balance_type_id = pbt.balance_type_id

Line 145: from pay_balance_dimensions

141:
142: cursor c_get_bal_dim_id(cp_legislation_code IN varchar2
143: ,cp_database_item_suffix in varchar2) is
144: select balance_dimension_id
145: from pay_balance_dimensions
146: where database_item_suffix = cp_database_item_suffix
147: and legislation_code = cp_legislation_code;
148:
149: