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_ASGN_EVENTS dependencies on PER_PERIODS_OF_PLACEMENT

Line 1341: -- assignments are collected from the table per_periods_of_placement.

1337: -- Cursor to get the assignment details of the assignment_id for assignment
1338: -- type 'Employee' and 'Contingent'. The hiring date, termination date and
1339: -- leaving reason for 'Employee' assignments collected from the table
1340: -- per_periods_of_service while the same details for the 'Contingent'
1341: -- assignments are collected from the table per_periods_of_placement.
1342: --
1343: CURSOR asg_csr IS
1344: SELECT
1345: GREATEST(ptu.effective_start_date, asg.effective_start_date) effective_start_date

Line 1374: ,per_periods_of_placement pop

1370: ,hpt.wkth_wktyp_code wkth_wktyp_code
1371: FROM per_all_assignments_f asg
1372: ,per_assignment_status_types ast
1373: ,per_periods_of_service pos
1374: ,per_periods_of_placement pop
1375: ,per_person_type_usages_f ptu
1376: ,hri_cs_prsntyp_ct hpt
1377: WHERE asg.assignment_id = g_assignment_id
1378: AND ast.assignment_status_type_id = asg.assignment_status_type_id