DBA Data[Home] [Help]

APPS.CN_QUOTA_PAY_ELEMENTS_PKG dependencies on CN_QUOTA_PAY_ELEMENTS_S

Line 37: SELECT cn_quota_pay_elements_s.nextval

33: PROCEDURE Get_UID( X_quota_pay_element_id IN OUT NUMBER) IS
34:
35: BEGIN
36:
37: SELECT cn_quota_pay_elements_s.nextval
38: INTO X_quota_pay_element_id
39: FROM dual;
40:
41: END Get_UID;

Line 285: l_start_date cn_quota_pay_elements.start_date%TYPE;

281:
282: l_quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE;
283: l_quota_id cn_quota_pay_elements.quota_id%TYPE;
284: l_pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE;
285: l_start_date cn_quota_pay_elements.start_date%TYPE;
286: l_end_date cn_quota_pay_elements.end_date%TYPE;
287: l_status cn_quota_pay_elements.status%TYPE;
288: l_attribute_category cn_quota_pay_elements.attribute_category%TYPE;
289: l_attribute1 cn_quota_pay_elements.attribute1%TYPE;

Line 287: l_status cn_quota_pay_elements.status%TYPE;

283: l_quota_id cn_quota_pay_elements.quota_id%TYPE;
284: l_pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE;
285: l_start_date cn_quota_pay_elements.start_date%TYPE;
286: l_end_date cn_quota_pay_elements.end_date%TYPE;
287: l_status cn_quota_pay_elements.status%TYPE;
288: l_attribute_category cn_quota_pay_elements.attribute_category%TYPE;
289: l_attribute1 cn_quota_pay_elements.attribute1%TYPE;
290: l_attribute2 cn_quota_pay_elements.attribute2%TYPE;
291: l_attribute3 cn_quota_pay_elements.attribute3%TYPE;