DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 832: FROM pay_defined_balances db

828: (p_business_group_id IN NUMBER
829: ,p_balance_name IN VARCHAR2
830: ,p_database_item_suffix IN VARCHAR) IS
831: SELECT db.defined_balance_id
832: FROM pay_defined_balances db
833: ,pay_balance_dimensions bd
834: ,pay_balance_types bt
835: WHERE bt.balance_name = p_balance_name
836: AND ((bt.business_group_id IS NULL AND bt.legislation_code = 'NO') OR (bt.legislation_code IS NULL AND bt.business_group_id = p_business_group_id))

Line 2272: FROM pay_defined_balances pdb

2268: CURSOR csr_seaman_bal_status
2269: (l_classification_id IN NUMBER
2270: ,l_defined_balance_id IN NUMBER) IS
2271: SELECT 'Y'
2272: FROM pay_defined_balances pdb
2273: ,pay_balance_classifications pbc
2274: WHERE pbc.classification_id = l_classification_id
2275: AND pdb.balance_type_id = pbc.balance_type_id
2276: AND pdb.defined_balance_id = l_defined_balance_id;