DBA Data[Home] [Help]

APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on PAY_BALANCE_DIMENSIONS

Line 3824: from pay_balance_types pbt,pay_balance_dimensions pbd, pay_defined_balances pdb

3820: )
3821: RETURN VARCHAR2 IS
3822: Cursor csr_balance(c_balance_id NUMBER,c_bg_id NUMBER) IS
3823: select pbt.balance_name||' - '||pbd.dimension_name name
3824: from pay_balance_types pbt,pay_balance_dimensions pbd, pay_defined_balances pdb
3825: where (pdb.business_group_id is null or pdb.business_group_id = c_bg_id )
3826: and pdb.balance_type_id = pbt.balance_type_id
3827: and pdb.balance_dimension_id = pbd.balance_dimension_id
3828: and pdb.defined_balance_id=c_balance_id;