DBA Data[Home] [Help]

APPS.PAY_RUN_BALANCE_WF_PKG dependencies on HR_LOOKUPS

Line 18: , hr_lookups hl

14: select pbv.run_balance_status
15: , pbv.balance_load_date
16: , hl.meaning
17: from pay_balance_validation pbv
18: , hr_lookups hl
19: where pbv.defined_balance_id = p_def_bal_id
20: and pbv.business_group_id = p_bg_id
21: and hl.lookup_type = 'RUN_BALANCE_STATUS'
22: and hl.lookup_code = pbv.run_balance_status;

Line 89: , hr_lookups hl

85: select pbd.dimension_level
86: , hl.meaning
87: from pay_balance_dimensions pbd
88: , pay_defined_balances db
89: , hr_lookups hl
90: where pbd.balance_dimension_id = db.balance_dimension_id
91: and db.defined_balance_id = p_defined_balance_id
92: and hl.lookup_type = 'PAY_BRA_BALANCE_LEVEL'
93: and hl.lookup_code = pbd.dimension_level;