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 PAY_ALL_PAYROLLS_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 111: pay_all_payrolls_f ppf,

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
115: WHERE paaf1.assignment_id = p_assignment_id

Line 138: pay_all_payrolls_f ppf,

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
142: WHERE paaf1.assignment_id = p_assignment_id

Line 229: pay_all_payrolls_f ppf,

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
233: WHERE paaf1.assignment_id = p_assignment_id

Line 254: pay_all_payrolls_f ppf,

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
258: WHERE paaf1.assignment_id = p_assignment_id

Line 374: pay_all_payrolls_f ppf,

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
378: WHERE paaf1.assignment_id = p_assignment_id

Line 399: pay_all_payrolls_f ppf,

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
403: WHERE paaf1.assignment_id = p_assignment_id

Line 538: pay_all_payrolls_f ppf,

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
542: WHERE paaf1.assignment_id = p_assignment_id

Line 564: pay_all_payrolls_f ppf,

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
568: WHERE paaf1.assignment_id = p_assignment_id