DBA Data[Home] [Help]

APPS.PAY_KW_SOE dependencies on HR_LOOKUPS

Line 32: ,hr_lookups hl

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

Line 33: ,hr_lookups hl1

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

Line 148: , hr_lookups hl

144: , pay_balance_dimensions bd
145: , pay_balance_types_tl bt
146: , hr_organization_information oi
147: , pay_balance_types pbt
148: , hr_lookups hl
149: where bad.attribute_name = p_balance_attribute
150: and ( bad.BUSINESS_GROUP_ID IS NULL
151: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
152: AND ( bad.LEGISLATION_CODE IS NULL