DBA Data[Home] [Help]

APPS.PQP_GB_SWF_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 633: from per_assignment_extra_info aei,

629: and :effective_date between paa.effective_start_date and paa.effective_end_date';
630: elsif g_addl_role_src = 'Assignment Developer DF' then
631: g_addl_role_sql_str:=
632: 'select pcv.pcv_information4
633: from per_assignment_extra_info aei,
634: pqp_configuration_values pcv
635: where aei.assignment_id = :p_assignment_id
636: and aei.information_type = '''||l_addl_role_context||'''
637: and pcv.pcv_information_category = ''PQP_GB_SWF_ROLE_MAPPING''

Line 2774: from per_assignment_extra_info

2770: and pcv.business_group_id = g_business_group_id;
2771:
2772: cursor get_daily_rate(p_assignment_id in number) is
2773: select aei_information1
2774: from per_assignment_extra_info
2775: where aei_information_category = 'PQP_SCHOOL_WORKFORCE_CENSUS'
2776: and assignment_id = p_assignment_id;
2777:
2778: cursor get_work_inc_type(p_person_id in number) is --- Check what are the valid values