269: piv.display_sequence line_number,
270: piv.input_value_id element_input_id ,
271: piv.uom uom, piv.name element_input_name
272: FROM cn_pay_element_inputs pei,
273: cn_quota_pay_elements qpe,
274: cn_payruns p,
275: cn_objects tab,
276: cn_objects col,
277: pay_element_types_f pet,
304: piv.uom uom, piv.name element_input_name
305: FROM
306: pay_input_values_f piv,
307: pay_element_types_f pet,
308: cn_quota_pay_elements qpe,
309: cn_payruns p
310: WHERE qpe.pay_element_type_id = p_element_type_id
311: AND qpe.quota_id = decode(p_incentive_type_code,
312: 'PMTPLN_REC' , -1001,
838:
839:
840: CURSOR get_quota_payelements(p_quotaId NUMBER,p_pay_date DATE) IS
841: select COUNT(*) from
842: cn_quota_pay_elements
843: where quota_id = p_quotaId
844: and p_pay_date
845: between
846: START_DATE and END_DATE;
847:
848: CURSOR get_num_pe_mapping (p_quota_id NUMBER) IS
849: select COUNT(*) from
850: cn_pay_element_inputs_all cp,
851: cn_quota_pay_elements_all cq
852: WHERE
853: cp.quota_pay_element_id = cq.quota_pay_element_id
854: AND cq.quota_id =p_quota_id;
855: