DBA Data[Home] [Help]

APPS.CN_SRP_PAY_GROUPS_PKG dependencies on CN_SRP_PAY_GROUPS_ALL

Line 66: INSERT INTO cn_srp_pay_groups_all(

62: THEN
63: Get_UID( X_srp_pay_group_id );
64: END IF;
65:
66: INSERT INTO cn_srp_pay_groups_all(
67: srp_pay_group_id
68: ,salesrep_id
69: ,pay_group_id
70: ,start_date

Line 169: UPDATE cn_srp_pay_groups_all

165: ,x_Last_Update_Login NUMBER
166: ,x_object_version_number IN OUT NOCOPY number) IS
167:
168: BEGIN
169: UPDATE cn_srp_pay_groups_all
170: SET
171: salesrep_id = x_salesrep_id,
172: pay_group_id = x_pay_group_id,
173: start_date = x_start_date,

Line 205: from cn_srp_pay_groups_all where srp_pay_group_id = x_srp_pay_group_id;

201: Raise NO_DATA_FOUND;
202: end if;
203:
204: select object_version_number into x_object_version_number
205: from cn_srp_pay_groups_all where srp_pay_group_id = x_srp_pay_group_id;
206:
207: END Update_Record;
208:
209: