DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_BALANCE_TYPES

Line 64: pay_balance_types b,

60: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
61: IS
62: SELECT defined_balance_id
63: FROM pay_defined_balances db,
64: pay_balance_types b,
65: pay_balance_dimensions d
66: WHERE b.balance_name = p_balance_name
67: AND d.dimension_name = p_dimension_name
68: AND db.balance_type_id = b.balance_type_id

Line 441: pay_balance_types b,

437: CURSOR get_defined_balance_id (p_balance_name VARCHAR2, p_dimension_name VARCHAR2)
438: IS
439: SELECT defined_balance_id
440: FROM pay_defined_balances db,
441: pay_balance_types b,
442: pay_balance_dimensions d
443: WHERE b.balance_name = p_balance_name
444: AND d.dimension_name = p_dimension_name
445: AND db.balance_type_id = b.balance_type_id