DBA Data[Home] [Help]

APPS.PAY_AU_FOREIGN_WORKERS dependencies on PAY_DEFINED_BALANCES

Line 66: FROM pay_defined_balances pdb

62:
63: CURSOR get_defined_balance_id
64: IS
65: SELECT pdb.defined_balance_id
66: FROM pay_defined_balances pdb
67: ,pay_balance_types pbt
68: ,pay_balance_dimensions pbd
69: WHERE pdb.balance_type_id = pbt.balance_type_id
70: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 684: FROM pay_defined_balances pdb

680: (c_balance_type_id pay_balance_types.balance_type_id%TYPE
681: ,c_dim_name pay_balance_dimensions.dimension_name%TYPE)
682: IS
683: SELECT pdb.defined_balance_id
684: FROM pay_defined_balances pdb
685: ,pay_balance_dimensions pbd
686: ,pay_balance_types pbt
687: WHERE pbt.balance_type_id = c_balance_type_id
688: AND pdb.balance_type_id = pbt.balance_type_id