APPS.CN_SRP_PAYEE_ASSIGNS_PKG dependencies on CN_SRP_PAYEE_ASSIGNS_ALL

Line 45: INSERT INTO cn_srp_payee_assigns_all (

41: SELECT cn_srp_payee_assigns_s.NEXTVAL
42: INTO x_srp_payee_assign_id
43: FROM dual;
44:
45: INSERT INTO cn_srp_payee_assigns_all (
46: srp_payee_assign_id
47: ,srp_quota_assign_id
48: ,org_id
49: ,payee_id

Line 97: UPDATE cn_srp_payee_assigns_all

93: ,p_Last_Updated_By NUMBER
94: ,p_Last_Update_Login NUMBER) IS
95: BEGIN
96:
97: UPDATE cn_srp_payee_assigns_all
98: SET
99: start_date = p_start_date,
100: end_date = p_end_date,
101: payee_id = p_payee_id,

Line 130: UPDATE cn_srp_payee_assigns_all

126: -- changes for bug#2753634, #3143462
127: -- changed the delete to update so that srp_payee_assign_id remains
128: -- and can be used for futuer revert operations - use delete_flag
129:
130: UPDATE cn_srp_payee_assigns_all
131: SET delete_flag = 'Y'
132: WHERE srp_payee_assign_id = p_srp_payee_assign_id;
133:
134: --DELETE FROM cn_srp_payee_assigns

Line 151: FROM cn_srp_payee_assigns_all

147: ,p_quota_id NUMBER) IS
148:
149: CURSOR get_payee_del_strdt_cur IS
150: SELECT srp_payee_assign_id
151: FROM cn_srp_payee_assigns_all
152: WHERE srp_quota_assign_id = p_srp_quota_assign_id
153: AND quota_id = p_quota_id ;
154:
155: BEGIN