APPS.PAY_AU_FOREIGN_WORKERS dependencies on PAY_BALANCE_TYPES

Line 67: ,pay_balance_types pbt

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
71: AND pbt.legislation_code = 'AU'

Line 680: (c_balance_type_id pay_balance_types.balance_type_id%TYPE

676: )
677: IS
678:
679: CURSOR csr_get_def_bal
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

Line 686: ,pay_balance_types pbt

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
689: AND pdb.balance_dimension_id = pbd.balance_dimension_id
690: AND pbd.dimension_name = c_dim_name;