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 HR_SOFT_CODING_KEYFLEX

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 1307: ,hr_soft_coding_keyflex scl_flx

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
1311: and paa.person_id BETWEEN p_start_person_id AND p_end_person_id