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 98: ,hr_soft_coding_keyflex hscl

94: ,paa.assignment_action_id
95: FROM per_assignments_f asg
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,hr_soft_coding_keyflex hscl
99: ,per_people_f ppf
100: WHERE asg.assignment_id = paa.assignment_id
101: AND paa.payroll_action_id = ppa.payroll_action_id
102: AND ppa.action_type in ('R','Q')

Line 165: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

161:
162: /* Cursor for fetching the person's assignment data */
163: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
164: SELECT hsck.segment2,paf.job_id
165: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
166: WHERE paf.person_id = l_person_id
167: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
168: AND hsck.segment1 = p_employer_id
169: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 682: ,hr_soft_coding_keyflex hscl

678: ,ppa.date_earned
679: FROM per_assignments_f asg
680: ,pay_assignment_actions paa
681: ,pay_payroll_actions ppa
682: ,hr_soft_coding_keyflex hscl
683: ,per_people_f ppf
684: WHERE asg.assignment_id = paa.assignment_id
685: AND paa.payroll_action_id = ppa.payroll_action_id
686: AND ppa.action_type in ('R','Q')

Line 707: ,hr_soft_coding_keyflex hscl

703: ,ppa.date_earned
704: FROM per_assignments_f asg
705: ,pay_assignment_actions paa
706: ,pay_payroll_actions ppa
707: ,hr_soft_coding_keyflex hscl
708: ,per_people_f ppf
709: WHERE asg.assignment_id = p_assignment_id
710: AND asg.assignment_id = paa.assignment_id
711: AND paa.payroll_action_id = ppa.payroll_action_id

Line 749: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

745:
746: /* Cursor for fetching the person's assignment data */
747: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
748: SELECT hsck.segment2
749: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
750: WHERE paf.person_id = l_person_id
751: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
752: AND hsck.segment1 = p_employer_id
753: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 1343: ,hr_soft_coding_keyflex hscl

1339: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1340: FROM per_assignments_f asg
1341: ,pay_assignment_actions paa
1342: ,pay_payroll_actions ppa
1343: ,hr_soft_coding_keyflex hscl
1344: ,per_periods_of_service pos
1345: ,per_people_f ppf
1346: WHERE asg.assignment_id = paa.assignment_id
1347: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1380: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

1376:
1377: /* Cursor for fetching the person's assignment data */
1378: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1379: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1380: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1381: WHERE paf.person_id = l_person_id
1382: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1383: AND hsck.segment1 = p_employer_id
1384: AND l_date between paf.effective_start_date and paf.effective_end_date;