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

Line 215: ,hr_soft_coding_keyflex hscl

211: select distinct asg.person_id,paa.assignment_action_id
212: from per_all_assignments_f asg
213: ,pay_assignment_actions paa
214: ,pay_payroll_actions ppa
215: ,hr_soft_coding_keyflex hscl
216: ,per_periods_of_service pos
217: where asg.assignment_id = paa.assignment_id
218: and paa.payroll_action_id = ppa.payroll_action_id
219: and pos.period_of_service_id = asg.period_of_service_id

Line 238: ,hr_soft_coding_keyflex hscl

234: select distinct asg.person_id, paa.assignment_action_id
235: from per_all_assignments_f asg
236: ,pay_assignment_actions paa
237: ,pay_payroll_actions ppa
238: ,hr_soft_coding_keyflex hscl
239: ,per_periods_of_service pos
240: where asg.assignment_id = paa.assignment_id
241: and paa.payroll_action_id = ppa.payroll_action_id
242: and pos.period_of_service_id = asg.period_of_service_id

Line 268: ,hr_soft_coding_keyflex hscl

264: cursor get_pid_new (p_org_id number,p_date date) is
265: select distinct asg.person_id,asg.assignment_id from per_all_assignments_f asg
266: ,pay_assignment_actions paa
267: ,pay_payroll_actions ppa
268: ,hr_soft_coding_keyflex hscl
269: ,per_periods_of_service pos
270: where asg.assignment_id = paa.assignment_id
271: and paa.payroll_action_id = ppa.payroll_action_id
272: and pos.period_of_service_id = asg.period_of_service_id

Line 287: ,hr_soft_coding_keyflex hscl

283: cursor get_assact_id_new (p_org_id number,p_date date,p_person_id number) is
284: select paa.assignment_action_id from per_all_assignments_f asg
285: ,pay_assignment_actions paa
286: ,pay_payroll_actions ppa
287: ,hr_soft_coding_keyflex hscl
288: ,per_periods_of_service pos
289: where rownum < 2
290: and asg.assignment_id = paa.assignment_id
291: and asg.person_id = p_person_id

Line 308: select /+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) / distinct asg.person_id, asg.assignment_id

304:
305: -- Cursor to get person_ids,assignment_ids of terminated emps
306: cursor get_pid_term (p_org_id number,p_date date) is
307: --and trunc(pps.actual_termination_date,'MM') = p_date;
308: select /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct asg.person_id, asg.assignment_id
309: from per_all_assignments_f asg
310: ,pay_assignment_actions paa
311: ,pay_payroll_actions ppa
312: ,hr_soft_coding_keyflex hscl

Line 312: ,hr_soft_coding_keyflex hscl

308: select /*+ INDEX(hscl, HR_SOFT_CODING_KEYFLEX_PK) */ distinct asg.person_id, asg.assignment_id
309: from per_all_assignments_f asg
310: ,pay_assignment_actions paa
311: ,pay_payroll_actions ppa
312: ,hr_soft_coding_keyflex hscl
313: ,per_periods_of_service pos
314: where asg.assignment_id = paa.assignment_id
315: and paa.payroll_action_id = ppa.payroll_action_id
316: and pos.period_of_service_id = asg.period_of_service_id

Line 354: ,hr_soft_coding_keyflex hscl

350: select paa.assignment_action_id
351: from per_all_assignments_f asg
352: ,pay_assignment_actions paa
353: ,pay_payroll_actions ppa
354: ,hr_soft_coding_keyflex hscl
355: ,per_periods_of_service pos
356: where rownum < 2
357: and asg.assignment_id = paa.assignment_id
358: and asg.person_id = p_person_id

Line 421: from hr_soft_coding_keyflex hsc, per_all_assignments_f paf

417: and trunc(p_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
418: --cursor to get GOSI number of the employees
419: cursor get_GOSI_number_new (p_person_id number) is
420: select segment2
421: from hr_soft_coding_keyflex hsc, per_all_assignments_f paf
422: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
423: and paf.person_id = p_person_id;
424: --cursor to get names of the terminated employees
425: cursor get_name_term (p_person_id number,p_date date) is

Line 431: from hr_soft_coding_keyflex hsc, per_all_assignments_f paf

427: and trunc(p_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
428: --cursor to get GOSI numbers of the terminated employees
429: cursor get_GOSI_number_term(p_person_id number) is
430: select segment2
431: from hr_soft_coding_keyflex hsc, per_all_assignments_f paf
432: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
433: and paf.person_id = p_person_id;
434: --cursor to get the termination details of the terminated employees
435: cursor get_details_term (p_person_id number) is

Line 1980: ,hr_soft_coding_keyflex hscl

1976: from pay_assignment_actions paa
1977: ,pay_payroll_actions ppa
1978: ,per_all_assignments_f paf
1979: ,per_periods_of_service pps
1980: ,hr_soft_coding_keyflex hscl
1981: ,per_time_periods ptp
1982: ,pay_run_results prr
1983: where paf.period_of_service_id = pps.period_of_service_id
1984: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))

Line 2008: ,hr_soft_coding_keyflex hscl

2004: from pay_assignment_actions paa
2005: ,pay_payroll_actions ppa
2006: ,per_all_assignments_f paf
2007: ,per_periods_of_service pps
2008: ,hr_soft_coding_keyflex hscl
2009: ,per_time_periods ptp
2010: ,pay_run_results prr
2011: where paf.period_of_service_id = pps.period_of_service_id
2012: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))

Line 2036: ,hr_soft_coding_keyflex hscl

2032: from pay_assignment_actions paa
2033: ,pay_payroll_actions ppa
2034: ,per_all_assignments_f paf
2035: ,per_periods_of_service pps
2036: ,hr_soft_coding_keyflex hscl
2037: ,per_time_periods ptp
2038: ,pay_run_results prr
2039: where paf.period_of_service_id = pps.period_of_service_id
2040: and nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY'))

Line 2661: select /+ INDEX(hsck, HR_SOFT_CODING_KEYFLEX_PK) / distinct assignment_id

2657: --and l_effective_date between paa.effective_start_date and paa.effective_end_date
2658: --and l_effective_date between peo.effective_start_date and peo.effective_end_date;
2659: /*Cursor to select assignments from a given GRE*/
2660: cursor csr_get_gre_assignments (l_employer_id number, l_business_group_id number, l_effective_date date,l_form_type varchar2) is
2661: select /*+ INDEX(hsck, HR_SOFT_CODING_KEYFLEX_PK) */ distinct assignment_id
2662: from per_all_assignments_f paa,
2663: hr_soft_coding_keyflex hsck,
2664: per_periods_of_service pos
2665: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 2663: hr_soft_coding_keyflex hsck,

2659: /*Cursor to select assignments from a given GRE*/
2660: cursor csr_get_gre_assignments (l_employer_id number, l_business_group_id number, l_effective_date date,l_form_type varchar2) is
2661: select /*+ INDEX(hsck, HR_SOFT_CODING_KEYFLEX_PK) */ distinct assignment_id
2662: from per_all_assignments_f paa,
2663: hr_soft_coding_keyflex hsck,
2664: per_periods_of_service pos
2665: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2666: and (nvl(hsck.segment3,'N') = 'Y' OR nvl(hsck.segment5,'N') = 'Y')
2667: and paa.business_group_id = l_business_group_id

Line 2689: ,hr_soft_coding_keyflex hsck

2685: select distinct has.assignment_id
2686: from hr_assignment_set_amendments has
2687: ,per_all_assignments_f paa
2688: ,per_periods_of_service pos
2689: ,hr_soft_coding_keyflex hsck
2690: where assignment_set_id = l_assignment_set_id
2691: and include_or_exclude = 'I'
2692: and has.assignment_id = paa.assignment_id
2693: --and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 2713: from hr_soft_coding_keyflex hscl

2709: and trunc(pos.actual_termination_date) <= trunc(l_effective_date)));
2710: /* Cursor to select Employee GOSI Number */
2711: cursor get_emp_gosi (l_assignment_id NUMBER, l_effective_date Date) is
2712: select hscl.segment2
2713: from hr_soft_coding_keyflex hscl
2714: ,per_all_assignments_f paa
2715: where hscl.SOFT_CODING_KEYFLEX_ID = paa.soft_CODING_KEYFLEX_ID
2716: and paa.assignment_id = l_assignment_id
2717: and hscl.id_flex_num = 20;

Line 2822: from hr_soft_coding_keyflex hscl

2818: /*Cursor to pick up GOSI hazards date*/
2819: cursor get_hazards_date (l_assignment_id NUMBER, l_effective_date Date) is
2820: select hscl.segment4,
2821: hscl.segment6
2822: from hr_soft_coding_keyflex hscl
2823: ,per_all_assignments_f paa
2824: where hscl.SOFT_CODING_KEYFLEX_ID = paa.soft_CODING_KEYFLEX_ID
2825: and paa.assignment_id = l_assignment_id
2826: and hscl.id_flex_num = 20;

Line 2831: from hr_soft_coding_keyflex hscl

2827: --and l_effective_date between paa.effective_start_date and paa.effective_end_date;
2828: /*Cursor to get employer for the employee*/
2829: cursor get_employer (l_assignment_id NUMBER, l_effective_date Date) is
2830: select hscl.segment1
2831: from hr_soft_coding_keyflex hscl
2832: ,per_all_assignments_f paa
2833: where hscl.SOFT_CODING_KEYFLEX_ID = paa.soft_CODING_KEYFLEX_ID
2834: and paa.assignment_id = l_assignment_id
2835: and hscl.id_flex_num = 20;

Line 2949: ,hr_soft_coding_keyflex hscl

2945: begin
2946: select 1 into i
2947: from hr_assignment_set_amendments haa
2948: ,per_all_assignments_f paa
2949: ,hr_soft_coding_keyflex hscl
2950: ,per_periods_of_service pos
2951: where assignment_set_id = p_assignment_set_id
2952: and include_or_exclude = 'I'
2953: and hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 2984: hr_soft_coding_keyflex hsck

2980: select distinct paa.assignment_id
2981: into t_emp(0).emp_id
2982: from per_all_assignments_f paa,
2983: per_periods_of_service pos,
2984: hr_soft_coding_keyflex hsck
2985: where paa.assignment_id = p_assignment_id
2986: --and p_effective_date between paa.effective_start_date and paa.effective_end_date
2987: and hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
2988: and hsck.ID_FLEX_NUM = 20