DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_EXPEND_TYP_SYS_LINKS_V

Line 950: FROM pa_expend_typ_sys_links_v

946: -- End of Performance Fix 4898314 SQL ID 14905832
947:
948: CURSOR get_expenditure_type_class IS
949: SELECT system_linkage_function
950: FROM pa_expend_typ_sys_links_v
951: WHERE expenditure_type = l_assignment_rec.expenditure_type
952: AND system_linkage_function in ('ST', 'OT');
953:
954: CURSOR check_team_template_wf IS

Line 3517: FROM pa_expend_typ_sys_links_v

3513: AND record_version_number = nvl (p_assignment_rec.record_version_number, record_version_number);
3514:
3515: CURSOR get_expenditure_type_class IS
3516: SELECT system_linkage_function
3517: FROM pa_expend_typ_sys_links_v
3518: WHERE expenditure_type = l_assignment_rec.expenditure_type
3519: AND system_linkage_function in ('ST', 'OT');
3520:
3521: CURSOR get_start_date IS