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_CBS_FILE dependencies on PER_ALL_ASSIGNMENTS_F

Line 522: from per_all_assignments_f paa,hr_soft_coding_keyflex sck

518:
519: cursor csr_get_working_schedule is
520: select sck.segment6,
521: SUM(decode(sign(p_reporting_end_date - paa.effective_end_date),-1,p_reporting_end_date,paa.effective_end_date)-decode(sign(paa.effective_start_date - p_reporting_start_date),-1,p_reporting_start_date,paa.effective_start_date)+1) Days
522: from per_all_assignments_f paa,hr_soft_coding_keyflex sck
523: where paa.assignment_id = p_assignment_id
524: and (paa.effective_start_date >= p_reporting_start_date or p_reporting_start_date between paa.effective_start_date and paa.effective_end_date)
525: and (paa.effective_end_date <= p_reporting_end_date or paa.effective_start_date <= p_reporting_end_date)
526: and sck.soft_coding_keyflex_id=paa.soft_coding_keyflex_id

Line 566: from per_all_assignments_f paa,hr_soft_coding_keyflex sck

562:
563: cursor csr_get_dev_work_hrs is
564: select sck.segment13,
565: SUM(decode(sign(p_reporting_end_date - paa.effective_end_date),-1,p_reporting_end_date,paa.effective_end_date)-decode(sign(paa.effective_start_date - p_reporting_start_date),-1,p_reporting_start_date,paa.effective_start_date)+1) Days
566: from per_all_assignments_f paa,hr_soft_coding_keyflex sck
567: where paa.assignment_id = p_assignment_id
568: and (paa.effective_start_date >= p_reporting_start_date or p_reporting_start_date between paa.effective_start_date and paa.effective_end_date)
569: and (paa.effective_end_date <= p_reporting_end_date or paa.effective_start_date <= p_reporting_end_date)
570: and sck.soft_coding_keyflex_id=paa.soft_coding_keyflex_id

Line 607: from per_all_assignments_f paa,hr_soft_coding_keyflex sck

603:
604: cursor csr_get_employmetnt_code is
605: select sck.segment6,paa.employment_category,
606: SUM(decode(sign(p_reporting_end_date - paa.effective_end_date),-1,p_reporting_end_date,paa.effective_end_date)-decode(sign(paa.effective_start_date - p_reporting_start_date),-1,p_reporting_start_date,paa.effective_start_date)+1) Days
607: from per_all_assignments_f paa,hr_soft_coding_keyflex sck
608: where paa.assignment_id = p_assignment_id
609: and (paa.effective_start_date >= p_reporting_start_date or p_reporting_start_date between paa.effective_start_date and paa.effective_end_date)
610: and (paa.effective_end_date <= p_reporting_end_date or paa.effective_start_date <= p_reporting_end_date)
611: and sck.soft_coding_keyflex_id=paa.soft_coding_keyflex_id

Line 663: from PER_ALL_ASSIGNMENTS_F paa,HR_SOFT_CODING_KEYFLEX sck

659: ) RETURN NUMBER is
660:
661: cursor csr_get_freq_ind_hours(l_assignment_id number ,l_reporting_date date) IS
662: select sck.segment28, paa.frequency
663: from PER_ALL_ASSIGNMENTS_F paa,HR_SOFT_CODING_KEYFLEX sck
664: where paa.assignment_id = l_assignment_id
665: and paa.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
666: and l_reporting_date between paa.effective_start_date and paa.effective_end_date;
667:

Line 1249: from per_all_assignments_f asg,

1245: p_rep_date DATE) return NUMBER IS
1246:
1247: cursor csr_asg_term is
1248: select max(asg.effective_end_date) asg_end_date
1249: from per_all_assignments_f asg,
1250: per_assignment_status_types past
1251: where asg.assignment_id = p_assignment_id
1252: and past.per_system_status = 'ACTIVE_ASSIGN'
1253: and asg.assignment_status_type_id = past.assignment_status_type_id

Line 1306: ,per_all_assignments_f paa

1302: pap.national_identifier,
1303: paa.grade_id
1304: from
1305: per_all_people_f pap
1306: ,per_all_assignments_f paa
1307: ,hr_soft_coding_keyflex scl_flx
1308: where
1309: pap.business_group_id =p_business_group_id
1310: and pap.person_id = paa.person_id

Line 1317: FROM per_assignment_status_types past, per_all_assignments_f asg

1313: and p_reporting_end_Date between pap.effective_start_date and pap.effective_end_date
1314: and paa.effective_start_date =
1315: (
1316: SELECT MIN(asg.effective_start_date)
1317: FROM per_assignment_status_types past, per_all_assignments_f asg
1318: WHERE asg.assignment_id = paa.assignment_id
1319: and past.per_system_status = 'ACTIVE_ASSIGN'
1320: and asg.assignment_status_type_id = past.assignment_status_type_id
1321: and asg.effective_start_date <= p_reporting_End_Date