APPS.CN_PAYRUN_PVT dependencies on CN_PAY_ELEMENT_INPUTS

Line 272: FROM cn_pay_element_inputs pei,

268: SELECT tab.name table_name , col.name column_name,
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,

Line 324: AND not exists ( select 1 from cn_pay_element_inputs cpei

320: AND qpe.end_date <= pet.effective_end_date
321: AND trunc(pet.effective_start_date) = trunc(piv.effective_start_date)
322: AND trunc(pet.effective_end_date) = trunc(piv.effective_end_date)
323: AND pet.element_type_id = piv.element_type_id
324: AND not exists ( select 1 from cn_pay_element_inputs cpei
325: WHERE cpei.quota_pay_element_id = qpe.quota_pay_element_id
326: AND qpe.pay_element_type_id = piv.element_type_id
327: AND cpei.element_input_id = piv.input_value_id )
328: ORDER by line_number, element_input_name ;

Line 850: cn_pay_element_inputs_all cp,

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;