DBA Data[Home] [Help]

APPS.PERFRPHR dependencies on PEFRUSDT

Line 109: AND 'Y' = pefrusdt.get_table_value(peo.business_group_id

105: (ast.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN') AND p_include_suspended = 'Y'))
106: AND asg.assignment_status_type_id = ast.assignment_status_type_id
107: AND asg.primary_flag = 'Y'
108: AND peo.person_type_id = pt.person_type_id
109: AND 'Y' = pefrusdt.get_table_value(peo.business_group_id
110: ,'FR_USER_PERSON_TYPE'
111: ,p_udt_column
112: ,pt.user_person_type
113: ,p_effective_date)

Line 144: AND 'Y' = pefrusdt.get_table_value(peo2.business_group_id

140: (ast2.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN') AND p_include_suspended = 'Y'))
141: AND asg2.assignment_status_type_id = ast2.assignment_status_type_id
142: AND asg2.primary_flag = 'Y'
143: AND peo2.person_type_id = pt2.person_type_id
144: AND 'Y' = pefrusdt.get_table_value(peo2.business_group_id
145: ,'FR_USER_PERSON_TYPE'
146: ,p_udt_column
147: ,pt2.user_person_type
148: ,p_effective_date)