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_KW_ANNUAL_REPORTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 113: ,hr_soft_coding_keyflex hscl

109: ,paa.assignment_action_id
110: FROM per_assignments_f asg
111: ,pay_assignment_actions paa
112: ,pay_payroll_actions ppa
113: ,hr_soft_coding_keyflex hscl
114: ,per_people_f ppf
115: WHERE asg.assignment_id = paa.assignment_id
116: AND paa.payroll_action_id = ppa.payroll_action_id
117: AND ppa.action_type in ('R','Q')

Line 180: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

176:
177: /* Cursor for fetching the person's assignment data */
178: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
179: SELECT hsck.segment2,paf.job_id
180: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
181: WHERE paf.person_id = l_person_id
182: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
183: AND hsck.segment1 = p_employer_id
184: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 740: ,hr_soft_coding_keyflex hscl

736: ,ppa.date_earned
737: FROM per_assignments_f asg
738: ,pay_assignment_actions paa
739: ,pay_payroll_actions ppa
740: ,hr_soft_coding_keyflex hscl
741: ,per_people_f ppf
742: WHERE asg.assignment_id = paa.assignment_id
743: AND paa.payroll_action_id = ppa.payroll_action_id
744: AND ppa.action_type in ('R','Q')

Line 765: ,hr_soft_coding_keyflex hscl

761: ,ppa.date_earned
762: FROM per_assignments_f asg
763: ,pay_assignment_actions paa
764: ,pay_payroll_actions ppa
765: ,hr_soft_coding_keyflex hscl
766: ,per_people_f ppf
767: WHERE asg.assignment_id = p_assignment_id
768: AND asg.assignment_id = paa.assignment_id
769: AND paa.payroll_action_id = ppa.payroll_action_id

Line 807: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

803:
804: /* Cursor for fetching the person's assignment data */
805: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
806: SELECT hsck.segment2
807: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
808: WHERE paf.person_id = l_person_id
809: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
810: AND hsck.segment1 = p_employer_id
811: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 1401: ,hr_soft_coding_keyflex hscl

1397: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1398: FROM per_assignments_f asg
1399: ,pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,hr_soft_coding_keyflex hscl
1402: ,per_periods_of_service pos
1403: ,per_people_f ppf
1404: WHERE asg.assignment_id = paa.assignment_id
1405: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1438: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

1434:
1435: /* Cursor for fetching the person's assignment data */
1436: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1437: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1438: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1439: WHERE paf.person_id = l_person_id
1440: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1441: AND hsck.segment1 = p_employer_id
1442: AND l_date between paf.effective_start_date and paf.effective_end_date;