APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on PER_ALL_ASSIGNMENTS_F

Line 904: from per_all_assignments_f '||

900: -- override to uniformed grade flag can be in Assignment Flexfield
901: debug('override to uniformed grade flag can be in Assignment Flexfield',20);
902:
903: /*l_query := 'select '||g_assignment_column||' '||'
904: from per_all_assignments_f '||
905: 'where business_group_id = '||g_business_group_id||' '||
906: 'and assignment_id = '||g_assignment_id||' '||
907: 'and ASS_ATTRIBUTE_CATEGORY = '||''''||g_assignment_context||''''||
908: 'and to_date('||''''||TO_CHAR(p_effective_date,'dd/mm/yyyy')||''''||

Line 913: 'from per_all_assignments_f '||' '||

909: ',''dd/mm/yyyy'')'||' between effective_start_date
910: and effective_end_date';*/
911:
912: l_query := 'select '||g_assignment_column||' '||
913: 'from per_all_assignments_f '||' '||
914: 'where business_group_id = '||g_business_group_id||' '||
915: 'and assignment_id = '||g_assignment_id||' ';
916: IF g_assignment_context <> 'Global Data Elements' THEN
917: l_query := l_query||

Line 1087: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

1083: END IF; --IF g_effective_date
1084: debug('l_chg_table: '||l_chg_table||' l_chg_type: '||l_chg_type);
1085:
1086: -- check for salary element end
1087: IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
1088: AND l_chg_column_name = 'GRADE_ID' THEN
1089: debug('Grade event ');
1090: IF l_chg_type = 'U' THEN
1091: debug('For update type pick the value from new_value',40);

Line 1158: l_grade_id per_all_assignments_f.grade_id%type;

1154: ,p_output OUT NOCOPY VARCHAR2
1155: ) RETURN NUMBER
1156: IS
1157: l_proc varchar2(72) := g_package||'.get_grade_code';
1158: l_grade_id per_all_assignments_f.grade_id%type;
1159: l_grade_change VARCHAR2(1);
1160: l_grade_code VARCHAR2(10);
1161: l_error NUMBER;
1162: l_old_value VARCHAR2(20);