eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_EOY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: from per_all_assignments_f paa

28: CURSOR get_all_assignments(p_assignment_id NUMBER
29: ,p_effective_date DATE --12576775
30: ,p_previous_year_start_date DATE) IS --12576775
31: select unique(paa1.assignment_id) assignment_id
32: from per_all_assignments_f paa
33: ,per_all_assignments_f paa1
34: where paa.assignment_id=p_assignment_id
35: and paa.person_id=paa1.person_id
36: --12576775 start

Line 33: ,per_all_assignments_f paa1

29: ,p_effective_date DATE --12576775
30: ,p_previous_year_start_date DATE) IS --12576775
31: select unique(paa1.assignment_id) assignment_id
32: from per_all_assignments_f paa
33: ,per_all_assignments_f paa1
34: where paa.assignment_id=p_assignment_id
35: and paa.person_id=paa1.person_id
36: --12576775 start
37: and paa1.payroll_id IS NOT NULL

Line 46: from per_all_assignments_f

42:
43: CURSOR get_payroll_id(p_assignment_id NUMBER
44: ,p_effective_date DATE) IS
45: select payroll_id
46: from per_all_assignments_f
47: where assignment_id=p_assignment_id
48: and p_effective_date between effective_start_date
49: and effective_end_date;
50:

Line 54: from per_all_assignments_f paa

50:
51: CURSOR get_dates(p_assignment_id NUMBER) IS
52: select min(paa.effective_start_date)
53: ,max(paa.effective_end_date)
54: from per_all_assignments_f paa
55: ,per_assignment_status_types pas
56: where assignment_id=p_assignment_id
57: and paa.assignment_status_type_id=pas.assignment_status_type_id
58: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN'

Line 114: FROM per_periods_of_service pp,per_all_assignments_f assg

110:
111: --15971960
112: CURSOR get_per_fpd(c_assignment_id NUMBER,c_asg_end_dt DATE) IS
113: SELECT pp.final_process_date
114: FROM per_periods_of_service pp,per_all_assignments_f assg
115: WHERE pp.person_id = assg.person_id
116: AND assg.assignment_id = c_assignment_id
117: AND pp.final_process_date > c_asg_end_dt
118: ORDER BY final_process_date DESC;

Line 1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;

1006:
1007: IS
1008:
1009: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

Line 1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;

1008:
1009: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1015: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1016: l_other_manager_warning boolean;

Line 1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

1009: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1015: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1016: l_other_manager_warning boolean;
1017: l_no_managers_warning boolean;

Line 1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

1010: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1015: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1016: l_other_manager_warning boolean;
1017: l_no_managers_warning boolean;
1018: l_hourly_salaried_warning boolean;

Line 1015: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;

1011: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1012: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1013: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1014: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1015: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1016: l_other_manager_warning boolean;
1017: l_no_managers_warning boolean;
1018: l_hourly_salaried_warning boolean;
1019: l_gsp_post_process_warning varchar2(2000);

Line 1020: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;

1016: l_other_manager_warning boolean;
1017: l_no_managers_warning boolean;
1018: l_hourly_salaried_warning boolean;
1019: l_gsp_post_process_warning varchar2(2000);
1020: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;
1021: l_end number;
1022: l_datetrack_update_mode varchar2(2000);
1023:
1024: ---------------------------------------------------------------------

Line 1040: from per_all_assignments_f asg

1036: ,asg.effective_start_date
1037: ,asg.effective_end_date
1038: , scl.segment12 last_year_sal
1039: -- , ast.user_status --12608988 Removed for performance optimization
1040: from per_all_assignments_f asg
1041: ,hr_soft_coding_keyflex scl
1042: ,per_assignment_status_types ast
1043: where organization_id in
1044: (select pose.organization_id_child

Line 1058: /*AND EXISTS (SELECT 1 from per_all_assignments_f paaf

1054: --and fnd_date.canonical_to_date(p_date) between effective_start_date and effective_end_date --12322620
1055: --12322620
1056: AND asg.effective_end_date >= fnd_date.canonical_to_date(p_date)
1057: --13604353
1058: /*AND EXISTS (SELECT 1 from per_all_assignments_f paaf
1059: where paaf.assignment_id = asg.assignment_id
1060: and fnd_date.canonical_to_date(p_date) -1 BETWEEN paaf.effective_start_date and paaf.effective_end_date
1061: )*/
1062:

Line 1094: FROM per_all_assignments_f asg

1090: tab_exceptions exception_info;
1091:
1092: CURSOR csr_get_asg_max_end_date(p_asg_id IN NUMBER) IS
1093: SELECT max (asg.effective_end_date) max_end_date
1094: FROM per_all_assignments_f asg
1095: WHERE asg.assignment_id = p_asg_id;
1096: --12608988 End
1097: Begin
1098: --hr_utility.trace_on(null,'RESET_OVERRIDE');

Line 1261: from per_all_assignments_f paa

1257: ,paa.effective_start_date
1258: ,paa.effective_end_date
1259: ,paa.object_version_number
1260: ,hsck.segment12
1261: from per_all_assignments_f paa
1262: ,hr_soft_coding_keyflex hsck
1263: ,per_assignment_status_types pas
1264: where person_id=p_person_id
1265: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)

Line 1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;

1269: and p_effective_date between effective_start_date and effective_end_date;
1270:
1271:
1272: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

Line 1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;

1271:
1272: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1278: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1279: l_other_manager_warning boolean;

Line 1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

1272: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1278: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1279: l_other_manager_warning boolean;
1280: l_no_managers_warning boolean;

Line 1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

1273: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1278: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1279: l_other_manager_warning boolean;
1280: l_no_managers_warning boolean;
1281: l_hourly_salaried_warning boolean;

Line 1278: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;

1274: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1275: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1276: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1277: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1278: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1279: l_other_manager_warning boolean;
1280: l_no_managers_warning boolean;
1281: l_hourly_salaried_warning boolean;
1282: l_gsp_post_process_warning varchar2(2000);

Line 1283: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;

1279: l_other_manager_warning boolean;
1280: l_no_managers_warning boolean;
1281: l_hourly_salaried_warning boolean;
1282: l_gsp_post_process_warning varchar2(2000);
1283: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;
1284:
1285: l_datetrack_update_mode varchar2(2000);
1286:
1287: