APPS.PAY_GB_NICAR_06042002 dependencies on PAY_ELEMENT_TYPES_F

Line 1472: csr2_element_name pay_element_types_f.element_name%type;

1468: --
1469: csr1_price_max number;
1470: csr1_ni_rate number;
1471: --
1472: csr2_element_name pay_element_types_f.element_name%type;
1473: csr2_pr number;
1474: csr2_rd number;
1475: csr2_rn number;
1476: csr2_mb number;

Line 1556: , pay_element_types_f_tl E_TL

1552: , pay_input_values_f ICC
1553: , pay_input_values_f IFS
1554: , pay_input_values_f IAP
1555: , pay_input_values_f ICO
1556: , pay_element_types_f_tl E_TL
1557: , pay_element_types_f E
1558: WHERE E_TL.element_type_id = E.element_type_id
1559: AND E.element_type_id = p_element_type_id
1560: AND userenv('LANG') = E_TL.language

Line 1557: , pay_element_types_f E

1553: , pay_input_values_f IFS
1554: , pay_input_values_f IAP
1555: , pay_input_values_f ICO
1556: , pay_element_types_f_tl E_TL
1557: , pay_element_types_f E
1558: WHERE E_TL.element_type_id = E.element_type_id
1559: AND E.element_type_id = p_element_type_id
1560: AND userenv('LANG') = E_TL.language
1561: AND IPR.element_type_id = E.element_type_id