DBA Data[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 78: ,pay_defined_balances db

74: ,c_dimension_name IN Varchar2
75: ,c_bg_id IN Number) IS
76: SELECT db.defined_balance_id
77: FROM pay_balance_types pbt
78: ,pay_defined_balances db
79: ,pay_balance_dimensions bd
80: WHERE pbt.balance_name = c_balance_name
81: AND pbt.balance_type_id = db.balance_type_id
82: AND bd.balance_dimension_id = db.balance_dimension_id

Line 100: FROM pay_defined_balances db

96: CURSOR csr_defined_bal1 (c_balance_type_id IN Number
97: ,c_dimension_name IN Varchar2
98: ,c_bg_id IN Number) IS
99: SELECT db.defined_balance_id
100: FROM pay_defined_balances db
101: ,pay_balance_dimensions bd
102: WHERE db.balance_type_id = c_balance_type_id
103: AND bd.balance_dimension_id = db.balance_dimension_id
104: AND bd.dimension_name = c_dimension_name

Line 646: , pay_defined_balances db

642: SELECT 1
643: FROM pay_run_results prr
644: , pay_run_result_values prv
645: , pay_balance_feeds_f pbf
646: , pay_defined_balances db
647: WHERE prr.assignment_action_id = paa.assignment_action_id
648: AND prv.run_result_id = prr.run_result_id
649: AND pbf.input_value_id = prv.input_value_id
650: AND prv.result_value IS NOT NULL