APPS.CN_PAYGROUP_PUB dependencies on CN_PAY_GROUPS

Line 60: FROM cn_pay_groups

56: attribute14,
57: attribute15,
58: object_version_number,
59: org_id
60: FROM cn_pay_groups
61: WHERE upper(name) like upper(p_search_name)
62: and (p_search_start_date is null
63: OR ( trunc(start_date) >= trunc(p_search_start_date)
64: AND

Line 206: FROM cn_pay_groups

202: l_api_name CONSTANT VARCHAR2(30) := 'Get_PayGroup_ID';
203:
204: CURSOR get_PayGroup_id(x_org_id NUMBER) is
205: SELECT pay_group_id
206: FROM cn_pay_groups
207: WHERE name = p_PayGroup_rec.name
208: AND start_date = p_PayGroup_rec.start_date
209: AND end_date = p_PayGroup_rec.end_date
210: and org_id= x_org_id;

Line 225: SELECT cn_pay_groups_s.nextval

221: FETCH get_PayGroup_id INTO l_get_PayGroup_id_rec;
222: IF get_PayGroup_id%ROWCOUNT = 0
223: THEN
224: x_status := 'NEW PAY GROUP';
225: SELECT cn_pay_groups_s.nextval
226: INTO x_pay_group_id
227: FROM dual;
228: ELSIF get_PayGroup_id%ROWCOUNT = 1
229: THEN

Line 252: -- CN_Pay_Groups_Pkg.Begin_Record

248: --------------------------------------------------------------------------+
249: -- Procedure : Create_PayGroup
250: -- Description: Public API to create a pay group
251: -- Calls : validate_pay_group
252: -- CN_Pay_Groups_Pkg.Begin_Record
253: --------------------------------------------------------------------------+
254: PROCEDURE Create_PayGroup(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 ,

Line 416: -- CN_Pay_Groups_Pkg.Begin_Record

412: ---------------------------------------------------------------------------+
413: -- Procedure : Update PayGroup
414: -- Description : This is a public procedure to update pay groups
415: -- Calls : validate_pay_group
416: -- CN_Pay_Groups_Pkg.Begin_Record
417: ---------------------------------------------------------------------------+
418:
419: PROCEDURE Update_PayGroup (
420: p_api_version IN NUMBER,