DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 79: ,pay_balance_dimensions bd

75: ,c_bg_id IN Number) IS
76: SELECT db.defined_balance_id
77: FROM pay_balance_types pbt
78: ,pay_defined_balances db
79: ,pay_balance_dimensions bd
80: WHERE pbt.balance_name = c_balance_name
81: AND pbt.balance_type_id = db.balance_type_id
82: AND bd.balance_dimension_id = db.balance_dimension_id
83: AND bd.dimension_name = c_dimension_name

Line 101: ,pay_balance_dimensions bd

97: ,c_dimension_name IN Varchar2
98: ,c_bg_id IN Number) IS
99: SELECT db.defined_balance_id
100: FROM pay_defined_balances db
101: ,pay_balance_dimensions bd
102: WHERE db.balance_type_id = c_balance_type_id
103: AND bd.balance_dimension_id = db.balance_dimension_id
104: AND bd.dimension_name = c_dimension_name
105: AND (