APPS.PAY_GB_EAS_SCOTLAND_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 44: pay_element_entry_values_f peev

40: FROM fnd_sessions fs,
41: pay_element_types_f pet,
42: pay_input_values_f piv,
43: pay_element_entries_f peef,
44: pay_element_entry_values_f peev
45: WHERE fs.session_id = userenv('sessionid')
46: AND pet.element_name = 'NI'
47: AND pet.business_group_id IS NULL
48: AND pet.legislation_code = 'GB'

Line 61: l_value pay_element_entry_values_f.screen_entry_value%TYPE

57: AND peef.element_entry_id = peev.element_entry_id
58: AND peev.input_value_id = piv.input_value_id
59: AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
60: --
61: l_value pay_element_entry_values_f.screen_entry_value%TYPE
62: BEGIN
63: hr_utility.trace('Entering GET_NI_PROCESS_TYPE: p_assignment_id='||p_assignment_id);
64: --
65: OPEN get_value;

Line 114: pay_element_entry_values_f peev

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')
117: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
118: AND paaf1.person_id = paaf2.person_id

Line 141: pay_element_entry_values_f peev

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')
144: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
145: AND paaf1.person_id = paaf2.person_id

Line 232: pay_element_entry_values_f peev

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')
235: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
236: AND paaf1.person_id = paaf2.person_id

Line 257: pay_element_entry_values_f peev

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')
260: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
261: AND paaf1.person_id = paaf2.person_id

Line 377: pay_element_entry_values_f peev

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')
380: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
381: AND paaf1.person_id = paaf2.person_id

Line 402: pay_element_entry_values_f peev

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')
405: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
406: AND paaf1.person_id = paaf2.person_id

Line 541: pay_element_entry_values_f peev

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')
544: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
545: AND paaf1.person_id = paaf2.person_id

Line 567: pay_element_entry_values_f peev

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')
570: AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
571: AND paaf1.person_id = paaf2.person_id

Line 589: FROM fnd_sessions fs, pay_element_entry_values_f peev

585: l_entry_id NUMBER;
586: --
587: CURSOR get_value IS
588: SELECT peev.screen_entry_value
589: FROM fnd_sessions fs, pay_element_entry_values_f peev
590: WHERE fs.session_id = userenv('sessionid')
591: AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
592: AND peev.element_entry_id = l_entry_id
593: AND peev.input_value_id IN (l_eas_iv_id, l_eas_ntpp_iv_id);

Line 595: l_value pay_element_entry_values_f.screen_entry_value%TYPE;

591: AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
592: AND peev.element_entry_id = l_entry_id
593: AND peev.input_value_id IN (l_eas_iv_id, l_eas_ntpp_iv_id);
594: --
595: l_value pay_element_entry_values_f.screen_entry_value%TYPE;
596: l_count NUMBER;
597: --
598: BEGIN
599: hr_utility.trace('Entering GET_MAIN_ENTRY_VALUE, p_assignment_id='||p_assignment_id||', p_input_value_name='||p_input_value_name);

Line 686: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;

682: RETURN l_value;
683: END get_main_fee;
684:
685: FUNCTION check_ref(p_assignment_id IN NUMBER, p_reference IN VARCHAR2) RETURN VARCHAR2 IS
686: l_main_ref pay_element_entry_values_f.screen_entry_value%TYPE;
687: l_count NUMBER;
688: BEGIN
689: hr_utility.trace('Entering CHECK_REF, p_assignment_id='||p_assignment_id||
690: ', p_reference='||p_reference);