DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on HR_LOOKUPS

Line 108: ,hr_lookups hl

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

Line 109: ,hr_lookups hl1

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

Line 224: , hr_lookups hl

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