DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on HR_LOOKUPS

Line 111: ,hr_lookups hl

107: ,hr_locations loc
108: ,per_grades_vl grd
109: ,pay_payrolls_f pay
110: ,pay_people_groups pg
111: ,hr_lookups hl
112: ,hr_lookups hl1
113: where asg.assignment_id = :assignment_id
114: and :effective_date
115: between asg.effective_start_date and asg.effective_end_date

Line 112: ,hr_lookups hl1

108: ,per_grades_vl grd
109: ,pay_payrolls_f pay
110: ,pay_people_groups pg
111: ,hr_lookups hl
112: ,hr_lookups hl1
113: where asg.assignment_id = :assignment_id
114: and :effective_date
115: between asg.effective_start_date and asg.effective_end_date
116: and asg.person_id = peo.person_id

Line 227: , hr_lookups hl

223: , pay_balance_dimensions bd
224: , pay_balance_types_tl bt
225: , hr_organization_information oi
226: , pay_balance_types pbt
227: , hr_lookups hl
228: where bad.attribute_name = p_balance_attribute
229: and ( bad.BUSINESS_GROUP_ID IS NULL
230: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
231: AND ( bad.LEGISLATION_CODE IS NULL