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 30: from per_all_assignments_f paa

26:
27:
28: CURSOR get_all_assignments(p_assignment_id NUMBER) IS
29: select unique(paa1.assignment_id) assignment_id
30: from per_all_assignments_f paa
31: ,per_all_assignments_f paa1
32: where paa.assignment_id=p_assignment_id
33: and paa.person_id=paa1.person_id;
34:

Line 31: ,per_all_assignments_f paa1

27:
28: CURSOR get_all_assignments(p_assignment_id NUMBER) IS
29: select unique(paa1.assignment_id) assignment_id
30: from per_all_assignments_f paa
31: ,per_all_assignments_f paa1
32: where paa.assignment_id=p_assignment_id
33: and paa.person_id=paa1.person_id;
34:
35:

Line 39: from per_all_assignments_f

35:
36: CURSOR get_payroll_id(p_assignment_id NUMBER
37: ,p_effective_date DATE) IS
38: select payroll_id
39: from per_all_assignments_f
40: where assignment_id=p_assignment_id
41: and p_effective_date between effective_start_date
42: and effective_end_date;
43:

Line 47: from per_all_assignments_f paa

43:
44: CURSOR get_dates(p_assignment_id NUMBER) IS
45: select min(paa.effective_start_date)
46: ,max(paa.effective_end_date)
47: from per_all_assignments_f paa
48: ,per_assignment_status_types pas
49: where assignment_id=p_assignment_id
50: and paa.assignment_status_type_id=pas.assignment_status_type_id
51: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN';

Line 958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;

954:
955: IS
956:
957: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

Line 960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;

956:
957: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
963: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
964: l_other_manager_warning boolean;

Line 961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

957: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
963: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
964: l_other_manager_warning boolean;
965: l_no_managers_warning boolean;

Line 962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

958: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
963: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
964: l_other_manager_warning boolean;
965: l_no_managers_warning boolean;
966: l_hourly_salaried_warning boolean;

Line 963: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;

959: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
960: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
961: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
962: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
963: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
964: l_other_manager_warning boolean;
965: l_no_managers_warning boolean;
966: l_hourly_salaried_warning boolean;
967: l_gsp_post_process_warning varchar2(2000);

Line 968: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;

964: l_other_manager_warning boolean;
965: l_no_managers_warning boolean;
966: l_hourly_salaried_warning boolean;
967: l_gsp_post_process_warning varchar2(2000);
968: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;
969: l_end number;
970: l_datetrack_update_mode varchar2(2000);
971:
972: ---------------------------------------------------------------------

Line 988: from per_all_assignments_f asg

984: ,asg.effective_start_date
985: ,asg.effective_end_date
986: , scl.segment12 last_year_sal
987: , ast.user_status
988: from per_all_assignments_f asg
989: ,hr_soft_coding_keyflex scl
990: , per_assignment_status_types ast
991: where organization_id in
992: (select pose.organization_id_child

Line 1118: from per_all_assignments_f paa

1114: ,paa.effective_start_date
1115: ,paa.effective_end_date
1116: ,paa.object_version_number
1117: ,hsck.segment12
1118: from per_all_assignments_f paa
1119: ,hr_soft_coding_keyflex hsck
1120: ,per_assignment_status_types pas
1121: where person_id=p_person_id
1122: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)

Line 1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;

1126: and p_effective_date between effective_start_date and effective_end_date;
1127:
1128:
1129: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

Line 1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;

1128:
1129: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1135: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1136: l_other_manager_warning boolean;

Line 1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;

1129: l_concatenated_segments hr_soft_coding_keyflex.CONCATENATED_SEGMENTS%TYPE;
1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1135: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1136: l_other_manager_warning boolean;
1137: l_no_managers_warning boolean;

Line 1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;

1130: l_cagr_grade_def_id per_all_assignments_f.CAGR_GRADE_DEF_ID%TYPE;
1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1135: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1136: l_other_manager_warning boolean;
1137: l_no_managers_warning boolean;
1138: l_hourly_salaried_warning boolean;

Line 1135: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;

1131: l_cagr_concatenated_segments per_cagr_grades_def.CONCATENATED_SEGMENTS%TYPE;
1132: l_effective_start_date per_all_assignments_f.EFFECTIVE_START_DATE%TYPE;
1133: l_effective_end_date per_all_assignments_f.EFFECTIVE_END_DATE%TYPE;
1134: l_comment_id per_all_assignments_f.COMMENT_ID%TYPE;
1135: l_soft_coding_keyflex_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE;
1136: l_other_manager_warning boolean;
1137: l_no_managers_warning boolean;
1138: l_hourly_salaried_warning boolean;
1139: l_gsp_post_process_warning varchar2(2000);

Line 1140: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;

1136: l_other_manager_warning boolean;
1137: l_no_managers_warning boolean;
1138: l_hourly_salaried_warning boolean;
1139: l_gsp_post_process_warning varchar2(2000);
1140: l_object_version_number per_all_assignments_f.OBJECT_VERSION_NUMBER%TYPE;
1141:
1142: l_datetrack_update_mode varchar2(2000);
1143:
1144: