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.HRI_OPL_SUPH_HST_INC dependencies on PER_ALL_ASSIGNMENTS_F

Line 92: (business_group_id per_all_assignments_f.business_group_id%TYPE

88: /******************************************************************************/
89:
90: /* Information to be held for each link in a chain */
91: TYPE g_link_record_type IS RECORD
92: (business_group_id per_all_assignments_f.business_group_id%TYPE
93: ,person_id per_all_assignments_f.person_id%TYPE
94: ,assignment_id per_all_assignments_f.assignment_id%TYPE
95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)

Line 93: ,person_id per_all_assignments_f.person_id%TYPE

89:
90: /* Information to be held for each link in a chain */
91: TYPE g_link_record_type IS RECORD
92: (business_group_id per_all_assignments_f.business_group_id%TYPE
93: ,person_id per_all_assignments_f.person_id%TYPE
94: ,assignment_id per_all_assignments_f.assignment_id%TYPE
95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)
97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE

Line 94: ,assignment_id per_all_assignments_f.assignment_id%TYPE

90: /* Information to be held for each link in a chain */
91: TYPE g_link_record_type IS RECORD
92: (business_group_id per_all_assignments_f.business_group_id%TYPE
93: ,person_id per_all_assignments_f.person_id%TYPE
94: ,assignment_id per_all_assignments_f.assignment_id%TYPE
95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)
97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE
98: ,leaf_node VARCHAR2(30)

Line 95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE

91: TYPE g_link_record_type IS RECORD
92: (business_group_id per_all_assignments_f.business_group_id%TYPE
93: ,person_id per_all_assignments_f.person_id%TYPE
94: ,assignment_id per_all_assignments_f.assignment_id%TYPE
95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)
97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE
98: ,leaf_node VARCHAR2(30)
99: ,end_date per_all_assignments_f.effective_end_date%TYPE);

Line 97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE

93: ,person_id per_all_assignments_f.person_id%TYPE
94: ,assignment_id per_all_assignments_f.assignment_id%TYPE
95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)
97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE
98: ,leaf_node VARCHAR2(30)
99: ,end_date per_all_assignments_f.effective_end_date%TYPE);
100:
101: /* Table type to hold information about the current chain */

Line 99: ,end_date per_all_assignments_f.effective_end_date%TYPE);

95: ,asg_status_id per_all_assignments_f.assignment_status_type_id%TYPE
96: ,invalid_flag VARCHAR2(30)
97: ,primary_asg_flag per_all_assignments_f.primary_flag%TYPE
98: ,leaf_node VARCHAR2(30)
99: ,end_date per_all_assignments_f.effective_end_date%TYPE);
100:
101: /* Table type to hold information about the current chain */
102: TYPE g_chain_type IS TABLE OF g_link_record_type INDEX BY BINARY_INTEGER;
103:

Line 237: FROM per_all_assignments_f asg,

233: /* subordinates. Hint seems obvious but on GSIAPDEV it was required */
234: CURSOR is_a_leaf_csr IS
235: SELECT /*+ index(ast PER_ASSIGNMENT_STATUS_TYPE_PK) use_nl(asg ast) */
236: 'N'
237: FROM per_all_assignments_f asg,
238: per_assignment_status_types ast
239: WHERE asg.supervisor_id = p_person_id
240: AND asg.assignment_type = 'E'
241: AND asg.primary_flag = 'Y'

Line 554: FROM per_all_assignments_f asg

550: /* Cursor to find whether top level supervisor is new */
551: /***********************************************************************/
552: CURSOR top_manager_new_csr IS
553: SELECT 'N'
554: FROM per_all_assignments_f asg
555: WHERE asg.supervisor_id = g_fetch_sup_id(p_index)
556: AND asg.assignment_type = 'E'
557: AND asg.primary_flag = 'Y'
558: AND p_change_date - 1

Line 640: per_all_assignments_f asg

636: ,asg.supervisor_id
637: ,asg.period_of_service_id
638: ,asg.primary_flag
639: FROM
640: per_all_assignments_f asg
641: WHERE asg.assignment_type = 'E'
642: AND asg.primary_flag = 'Y'
643: AND p_change_date
644: BETWEEN asg.effective_start_date AND asg.effective_end_date) hier

Line 845: per_all_assignments_f asg

841: ,asg.period_of_service_id
842: ,asg.supervisor_id
843: ,asg.primary_flag
844: FROM
845: per_all_assignments_f asg
846: WHERE asg.assignment_type = 'E'
847: AND asg.primary_flag = 'Y'
848: AND p_change_date
849: BETWEEN asg.effective_start_date AND asg.effective_end_date) hier

Line 1144: per_all_assignments_f asg

1140: 'CHNG') event_code
1141: ,pos.actual_termination_date termination_date
1142: ,pos.final_process_date final_process_date
1143: FROM
1144: per_all_assignments_f asg
1145: ,per_periods_of_service pos
1146: ,per_all_assignments_f prev_asg
1147: WHERE asg.primary_flag = 'Y'
1148: AND prev_asg.primary_flag (+) = 'Y'

Line 1146: ,per_all_assignments_f prev_asg

1142: ,pos.final_process_date final_process_date
1143: FROM
1144: per_all_assignments_f asg
1145: ,per_periods_of_service pos
1146: ,per_all_assignments_f prev_asg
1147: WHERE asg.primary_flag = 'Y'
1148: AND prev_asg.primary_flag (+) = 'Y'
1149: AND asg.assignment_type = 'E'
1150: AND prev_asg.assignment_type (+) = 'E'

Line 1180: per_all_assignments_f asg

1176: ,'TERM' event_code
1177: ,pos.actual_termination_date termination_date
1178: ,pos.final_process_date final_process_date
1179: FROM
1180: per_all_assignments_f asg
1181: ,per_periods_of_service pos
1182: WHERE asg.effective_end_date = pos.actual_termination_date
1183: AND (pos.actual_termination_date BETWEEN p_collect_from AND p_collect_to
1184: OR pos.final_process_date BETWEEN p_collect_from AND p_collect_to)

Line 1206: per_all_assignments_f sub_asg

1202: ,'ORPH' event_code
1203: ,sub_pps.actual_termination_date actual_termination_date
1204: ,sub_pps.final_process_date final_process_date
1205: FROM
1206: per_all_assignments_f sub_asg
1207: ,per_periods_of_service pps
1208: ,per_periods_of_service sub_pps
1209: WHERE pps.final_process_date BETWEEN p_collect_from AND p_collect_to
1210: AND sub_asg.supervisor_id = pps.person_id