DBA Data[Home] [Help]

APPS.PAY_AE_SOE dependencies on HR_LOOKUPS

Line 34: ,hr_lookups hl

30: ,hr_locations loc
31: ,per_grades_vl grd
32: ,pay_payrolls_f pay
33: ,pay_people_groups pg
34: ,hr_lookups hl
35: ,hr_lookups hl1
36: where asg.assignment_id = :assignment_id
37: and :effective_date
38: between asg.effective_start_date and asg.effective_end_date

Line 35: ,hr_lookups hl1

31: ,per_grades_vl grd
32: ,pay_payrolls_f pay
33: ,pay_people_groups pg
34: ,hr_lookups hl
35: ,hr_lookups hl1
36: where asg.assignment_id = :assignment_id
37: and :effective_date
38: between asg.effective_start_date and asg.effective_end_date
39: and asg.person_id = peo.person_id

Line 153: , hr_lookups hl

149: , pay_balance_dimensions bd
150: , pay_balance_types_tl bt
151: , hr_organization_information oi
152: , pay_balance_types pbt
153: , hr_lookups hl
154: where bad.attribute_name = p_balance_attribute
155: and ( bad.BUSINESS_GROUP_ID IS NULL
156: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
157: AND ( bad.LEGISLATION_CODE IS NULL