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 PER_ALL_ASSIGNMENTS_F

Line 13: FROM per_all_assignments_f paaf, pay_all_payrolls_f pap, per_time_period_types ptpt, fnd_sessions fs

9: FUNCTION get_current_freq(p_assignment_id IN NUMBER) RETURN NUMBER IS
10: --
11: CURSOR get_freq IS
12: SELECT ptpt.number_per_fiscal_year
13: FROM per_all_assignments_f paaf, pay_all_payrolls_f pap, per_time_period_types ptpt, fnd_sessions fs
14: WHERE fs.session_id = userenv('sessionid')
15: AND paaf.assignment_id = p_assignment_id
16: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_Date
17: AND pap.payroll_id = paaf.payroll_id

Line 80: per_all_assignments_f paaf

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
82: AND fs.session_id = userenv('sessionid')
83: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
84: AND ppf.payroll_id = paaf.payroll_id

Line 109: per_all_assignments_f paaf1,

105: --
106: CURSOR get_main_count(p_asg_tax_ref IN VARCHAR2) IS
107: SELECT count(*) cnt
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,

Line 110: per_all_assignments_f paaf2,

106: CURSOR get_main_count(p_asg_tax_ref IN VARCHAR2) IS
107: SELECT count(*) cnt
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

Line 136: per_all_assignments_f paaf1,

132: --
133: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
134: SELECT 1 cnt
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,

Line 137: per_all_assignments_f paaf2,

133: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
134: SELECT 1 cnt
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

Line 205: per_all_assignments_f paaf

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
207: AND fs.session_id = userenv('sessionid')
208: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
209: AND ppf.payroll_id = paaf.payroll_id

Line 227: per_all_assignments_f paaf1,

223: --
224: CURSOR get_main_payroll_id IS
225: SELECT ppf.payroll_id
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,

Line 228: per_all_assignments_f paaf2,

224: CURSOR get_main_payroll_id IS
225: SELECT ppf.payroll_id
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

Line 252: per_all_assignments_f paaf1,

248: --
249: CURSOR get_prim_payroll_id IS
250: SELECT ppf.payroll_id
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,

Line 253: per_all_assignments_f paaf2,

249: CURSOR get_prim_payroll_id IS
250: SELECT ppf.payroll_id
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

Line 359: per_all_assignments_f paaf

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
361: AND fs.session_id = userenv('sessionid')
362: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
363: AND ppf.payroll_id = paaf.payroll_id

Line 372: per_all_assignments_f paaf1,

368: --
369: CURSOR get_main_payroll_id IS
370: SELECT ppf.payroll_id
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,

Line 373: per_all_assignments_f paaf2,

369: CURSOR get_main_payroll_id IS
370: SELECT ppf.payroll_id
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

Line 397: per_all_assignments_f paaf1,

393: --
394: CURSOR get_prim_payroll_id IS
395: SELECT ppf.payroll_id
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,

Line 398: per_all_assignments_f paaf2,

394: CURSOR get_prim_payroll_id IS
395: SELECT ppf.payroll_id
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

Line 504: per_all_assignments_f paaf

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
506: AND fs.session_id = userenv('sessionid')
507: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
508: AND ppf.payroll_id = paaf.payroll_id

Line 536: per_all_assignments_f paaf1,

532: --
533: CURSOR get_main_entry_id IS
534: SELECT peef.element_entry_id
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,

Line 537: per_all_assignments_f paaf2,

533: CURSOR get_main_entry_id IS
534: SELECT peef.element_entry_id
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

Line 562: per_all_assignments_f paaf1,

558: --
559: CURSOR chk_prim_entry_id IS
560: SELECT peef.element_entry_id
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,

Line 563: per_all_assignments_f paaf2,

559: CURSOR chk_prim_entry_id IS
560: SELECT peef.element_entry_id
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