APPS.PAY_PAYGBRRS_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_X

Line 9: pay_element_types_x pet,

5: begin
6: begin
7: /*srw.user_exit('FND SRWINIT');*/null;
8: select input_value_id into CP_NI_Input_Value_ID from
9: pay_element_types_x pet,
10: pay_input_values_x piv
11: where pet.system_element_name = 'NI'
12: and piv.system_name = 'Category'
13: and pet.element_type_id = piv.element_type_id

Line 18: pay_element_types_x pet,

14: and pet.legislation_code = 'GB';
15: begin
16: select piv.input_value_id,piv2.input_value_id
17: into CP_Tax_Code_Input_Value_ID ,CP_Tax_Basis_Input_Value_ID from
18: pay_element_types_x pet,
19: pay_input_values_x piv,
20: pay_input_values_x piv2
21: where pet.system_element_name = 'PAYE'
22: and piv.system_name = 'Tax Code'

Line 30: pay_element_types_x pet,

26: and pet.legislation_code = 'GB';
27: exception when no_data_found then
28: select piv.input_value_id,piv2.input_value_id
29: into CP_Tax_Code_Input_Value_ID ,CP_Tax_Basis_Input_Value_ID from
30: pay_element_types_x pet,
31: pay_input_values_x piv,
32: pay_input_values_x piv2
33: where pet.system_element_name = 'PAYE Details'
34: and piv.system_name = 'Tax Code'