APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 58: FROM pay_element_classifications

54: AND business_group_id = p_business_group_id;
55: ELSIF p_creator_type = 'EC' THEN
56: SELECT classification_id
57: INTO l_creator_id
58: FROM pay_element_classifications
59: WHERE classification_name = p_creator_name
60: AND business_group_id = p_business_group_id;
61: ELSE
62: RAISE no_data_found;

Line 572: pay_element_classifications pec

568: select bc.classification_id, pbf.input_value_id,
569: pbf.scale, pbf.element_type_id
570: from pay_balance_feeds_v pbf,
571: pay_balance_classifications bc,
572: pay_element_classifications pec
573: where nvl(pbf.balance_initialization_flag,'N') = 'N'
574: and nvl(pbf.business_group_id,
575: p_business_group_id) = p_business_group_id
576: and nvl(pbf.legislation_code, 'NL') = 'NL'