APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 327: from pay_element_classifications

323: and business_group_id = p_business_group_id;
324: elsif p_creator_type = 'EC' then
325: select classification_id
326: into l_creator_id
327: from pay_element_classifications
328: where classification_name = p_creator_name
329: -- and legislation_code = g_legislation_code
330: and business_group_id = p_business_group_id;
331: else

Line 521: pay_element_classifications pec,

517: select bc.classification_id, pbf.input_value_id,
518: pbf.scale, pbf.element_type_id
519: from pay_balance_feeds_v pbf,
520: pay_balance_classifications bc,
521: pay_element_classifications pec,
522: pay_element_classifications_tl pect,
523: pay_balance_types_tl pbtl
524: where nvl(pbf.balance_initialization_flag,'N') = 'N'
525: and nvl(pbf.business_group_id,

Line 522: pay_element_classifications_tl pect,

518: pbf.scale, pbf.element_type_id
519: from pay_balance_feeds_v pbf,
520: pay_balance_classifications bc,
521: pay_element_classifications pec,
522: pay_element_classifications_tl pect,
523: pay_balance_types_tl pbtl
524: where nvl(pbf.balance_initialization_flag,'N') = 'N'
525: and nvl(pbf.business_group_id,
526: p_business_group_id) = p_business_group_id