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

Line 77: FROM hr_soft_coding_keyflex scl,

73: FUNCTION count_main_eas_entry(p_assignment_id IN NUMBER) RETURN NUMBER IS
74:
75: CURSOR get_asg_tax_ref IS
76: SELECT scl.segment1
77: FROM hr_soft_coding_keyflex scl,
78: fnd_sessions fs,
79: pay_payrolls_f ppf,
80: per_all_assignments_f paaf
81: WHERE paaf.assignment_id = p_assignment_id

Line 88: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

84: AND ppf.payroll_id = paaf.payroll_id
85: AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
86: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
87: --
88: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
89: --
90: CURSOR get_input_value_id(p_ele_name IN VARCHAR2) IS
91: SELECT piv.input_value_id
92: FROM fnd_sessions fs,

Line 112: hr_soft_coding_keyflex scl,

108: FROM fnd_sessions fs,
109: per_all_assignments_f paaf1,
110: per_all_assignments_f paaf2,
111: pay_all_payrolls_f ppf,
112: hr_soft_coding_keyflex scl,
113: pay_element_entries_f peef,
114: pay_element_entry_values_f peev
115: WHERE paaf1.assignment_id = p_assignment_id
116: AND fs.session_id = userenv('sessionid')

Line 139: hr_soft_coding_keyflex scl,

135: FROM fnd_sessions fs,
136: per_all_assignments_f paaf1,
137: per_all_assignments_f paaf2,
138: pay_all_payrolls_f ppf,
139: hr_soft_coding_keyflex scl,
140: pay_element_entries_f peef,
141: pay_element_entry_values_f peev
142: WHERE paaf1.assignment_id = p_assignment_id
143: AND fs.session_id = userenv('sessionid')

Line 202: FROM hr_soft_coding_keyflex scl,

198: FUNCTION get_main_eas_pay_date(p_assignment_id IN NUMBER) RETURN DATE IS
199:
200: CURSOR get_asg_tax_ref IS
201: SELECT scl.segment1, ppf.payroll_id
202: FROM hr_soft_coding_keyflex scl,
203: fnd_sessions fs,
204: pay_payrolls_f ppf,
205: per_all_assignments_f paaf
206: WHERE paaf.assignment_id = p_assignment_id

Line 213: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

209: AND ppf.payroll_id = paaf.payroll_id
210: AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
211: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
212: --
213: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
214: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
215: l_asg_period_start_date per_time_periods.start_date%TYPE;
216: --
217: CURSOR get_asg_period_start_date IS

Line 230: hr_soft_coding_keyflex scl,

226: FROM fnd_sessions fs,
227: per_all_assignments_f paaf1,
228: per_all_assignments_f paaf2,
229: pay_all_payrolls_f ppf,
230: hr_soft_coding_keyflex scl,
231: pay_element_entries_f peef,
232: pay_element_entry_values_f peev
233: WHERE paaf1.assignment_id = p_assignment_id
234: AND fs.session_id = userenv('sessionid')

Line 255: hr_soft_coding_keyflex scl,

251: FROM fnd_sessions fs,
252: per_all_assignments_f paaf1,
253: per_all_assignments_f paaf2,
254: pay_all_payrolls_f ppf,
255: hr_soft_coding_keyflex scl,
256: pay_element_entries_f peef,
257: pay_element_entry_values_f peev
258: WHERE paaf1.assignment_id = p_assignment_id
259: AND fs.session_id = userenv('sessionid')

Line 356: FROM hr_soft_coding_keyflex scl,

352: FUNCTION get_main_eas_freq(p_assignment_id IN NUMBER) RETURN NUMBER IS
353:
354: CURSOR get_asg_tax_ref IS
355: SELECT scl.segment1
356: FROM hr_soft_coding_keyflex scl,
357: fnd_sessions fs,
358: pay_payrolls_f ppf,
359: per_all_assignments_f paaf
360: WHERE paaf.assignment_id = p_assignment_id

Line 367: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

363: AND ppf.payroll_id = paaf.payroll_id
364: AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
365: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
366: --
367: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
368: --
369: CURSOR get_main_payroll_id IS
370: SELECT ppf.payroll_id
371: FROM fnd_sessions fs,

Line 375: hr_soft_coding_keyflex scl,

371: FROM fnd_sessions fs,
372: per_all_assignments_f paaf1,
373: per_all_assignments_f paaf2,
374: pay_all_payrolls_f ppf,
375: hr_soft_coding_keyflex scl,
376: pay_element_entries_f peef,
377: pay_element_entry_values_f peev
378: WHERE paaf1.assignment_id = p_assignment_id
379: AND fs.session_id = userenv('sessionid')

Line 400: hr_soft_coding_keyflex scl,

396: FROM fnd_sessions fs,
397: per_all_assignments_f paaf1,
398: per_all_assignments_f paaf2,
399: pay_all_payrolls_f ppf,
400: hr_soft_coding_keyflex scl,
401: pay_element_entries_f peef,
402: pay_element_entry_values_f peev
403: WHERE paaf1.assignment_id = p_assignment_id
404: AND fs.session_id = userenv('sessionid')

Line 501: FROM hr_soft_coding_keyflex scl,

497: p_count OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
498:
499: CURSOR get_asg_tax_ref IS
500: SELECT scl.segment1
501: FROM hr_soft_coding_keyflex scl,
502: fnd_sessions fs,
503: pay_payrolls_f ppf,
504: per_all_assignments_f paaf
505: WHERE paaf.assignment_id = p_assignment_id

Line 512: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

508: AND ppf.payroll_id = paaf.payroll_id
509: AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
510: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
511: --
512: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
513: --
514: CURSOR get_input_value_id(p_ele_name IN VARCHAR2, p_iv_name IN VARCHAR2) IS
515: SELECT piv.input_value_id
516: FROM fnd_sessions fs,

Line 539: hr_soft_coding_keyflex scl,

535: FROM fnd_sessions fs,
536: per_all_assignments_f paaf1,
537: per_all_assignments_f paaf2,
538: pay_all_payrolls_f ppf,
539: hr_soft_coding_keyflex scl,
540: pay_element_entries_f peef,
541: pay_element_entry_values_f peev
542: WHERE paaf1.assignment_id = p_assignment_id
543: AND fs.session_id = userenv('sessionid')

Line 565: hr_soft_coding_keyflex scl,

561: FROM fnd_sessions fs,
562: per_all_assignments_f paaf1,
563: per_all_assignments_f paaf2,
564: pay_all_payrolls_f ppf,
565: hr_soft_coding_keyflex scl,
566: pay_element_entries_f peef,
567: pay_element_entry_values_f peev
568: WHERE paaf1.assignment_id = p_assignment_id
569: AND fs.session_id = userenv('sessionid')