DBA Data[Home] [Help]

APPS.PAY_GB_EAS_SCOTLAND_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 41: pay_element_types_f pet,

37:
38: CURSOR get_value IS
39: SELECT nvl(min(peev.screen_entry_value), 'NP')
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')

Line 93: pay_element_types_f pet,

89: --
90: CURSOR get_input_value_id(p_ele_name IN VARCHAR2) IS
91: SELECT piv.input_value_id
92: FROM fnd_sessions fs,
93: pay_element_types_f pet,
94: pay_input_values_f piv
95: WHERE fs.session_id = userenv('sessionid')
96: AND pet.element_name = p_ele_name
97: AND pet.business_group_id IS NULL

Line 517: pay_element_types_f pet,

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,
517: pay_element_types_f pet,
518: pay_input_values_f piv
519: WHERE fs.session_id = userenv('sessionid')
520: AND pet.element_name = p_ele_name
521: AND pet.business_group_id IS NULL