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_SERVICE

Line 1340: -- per_periods_of_service while the same details for the 'Contingent'

1336: --
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

Line 1373: ,per_periods_of_service pos

1369: ,nvl(decode(hpt.include_flag_code,'Y',1,0),1) summarization_rqd_ind
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

Line 4689: per_periods_of_service pos,

4685: 0 perf_band_change_ind,
4686: hpt.prsntyp_sk_pk prsntyp_sk_fk,
4687: 1 summarization_rqd_ind
4688: FROM per_all_assignments_f asg,
4689: per_periods_of_service pos,
4690: hri_cs_prsntyp_ct hpt,
4691: per_person_type_usages_f ptu
4692: WHERE asg.assignment_type = 'E'
4693: AND asg.primary_flag = 'Y'