DBA Data[Home] [Help]

APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on CN_QUOTAS

Line 9: quota_name cn_quotas.name%TYPE,

5: -- Record type for quota Pay Element
6: --
7: TYPE quota_pay_element_rec_type IS RECORD
8: (quota_pay_element_id cn_quota_pay_elements.quota_pay_element_id%TYPE,
9: quota_name cn_quotas.name%TYPE,
10: pay_element_name pay_element_types.element_name%TYPE,
11: pay_start_date pay_element_types.effective_start_date%TYPE
12: := CN_API.G_MISS_DATE,
13: pay_end_date pay_element_types.effective_end_date%TYPE

Line 17: quota_id cn_quotas.quota_id%TYPE,

13: pay_end_date pay_element_types.effective_end_date%TYPE
14: := CN_API.G_MISS_DATE,
15: status cn_quota_pay_elements.status%TYPE
16: := CN_API.G_MISS_CHAR,
17: quota_id cn_quotas.quota_id%TYPE,
18: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
19: START_DATE cn_quota_pay_elements.start_date%TYPE
20: := CN_API.G_MISS_DATE,
21: END_DATE cn_quota_pay_elements.end_date%TYPE

Line 77: quota_name cn_quotas.name%TYPE,

73: pay_element_type_id cn_quota_pay_elements.pay_element_type_id%TYPE,
74: status cn_quota_pay_elements.status%TYPE,
75: start_date cn_quota_pay_elements.start_date%TYPE,
76: end_date cn_quota_pay_elements.end_date%TYPE,
77: quota_name cn_quotas.name%TYPE,
78: pay_element_name pay_element_types.element_name%TYPE,
79: pay_start_date cn_quota_pay_elements.start_date%TYPE,
80: pay_end_date cn_quota_pay_elements.end_date%TYPE
81: );

Line 249: p_quota_name IN cn_quotas.name%TYPE,

245: p_validation_level IN NUMBER,
246: x_return_status OUT VARCHAR2,
247: x_msg_count OUT NUMBER,
248: x_msg_data OUT VARCHAR2,
249: p_quota_name IN cn_quotas.name%TYPE,
250: p_pay_element_name IN pay_element_types.element_name%TYPE,
251: p_start_record IN NUMBER,
252: p_increment_count IN NUMBER,
253: p_order_by IN VARCHAR2,