DBA Data[Home] [Help]

APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on PAY_ELEMENT_TYPES

Line 10: pay_element_name pay_element_types.element_name%TYPE,

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
14: := CN_API.G_MISS_DATE,

Line 11: pay_start_date pay_element_types.effective_start_date%TYPE

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
14: := CN_API.G_MISS_DATE,
15: status cn_quota_pay_elements.status%TYPE

Line 13: pay_end_date pay_element_types.effective_end_date%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
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,

Line 78: pay_element_name pay_element_types.element_name%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: );
82:

Line 250: p_pay_element_name IN pay_element_types.element_name%TYPE,

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,
254: x_quota_pay_element_tbl OUT quota_pay_element_out_tbl_type,