DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 77: g_ele_classification_name pay_element_classifications.classification_name%type default null;

73: -- Deletion mode. --
74: --------------------
75: g_zap_deletion_mode constant varchar2(30) default 'ZAP';
76:
77: g_ele_classification_name pay_element_classifications.classification_name%type default null;
78:
79: -- ----------------------------------------------------------------------------
80: -- |-------------------------< get_formula_type_id >--------------------------|
81: -- ----------------------------------------------------------------------------

Line 155: from pay_element_classifications

151: ,p_classification in varchar2
152: ) is
153: select classification_id
154: , non_payments_flag
155: from pay_element_classifications
156: where upper(classification_name) = p_classification
157: and
158: (
159: (business_group_id is null and legislation_code is null)