APPS.OZF_NA_DDN_RULE_PVT dependencies on OZF_NA_DEDUCTION_RULES_B

Line 104: SELECT ozf_na_deduction_rules_b_s.NEXTVAL

100: l_org_id NUMBER := FND_API.G_MISS_NUM;
101: l_na_deduction_rule_id NUMBER;
102: l_dummy NUMBER;
103: CURSOR c_id IS
104: SELECT ozf_na_deduction_rules_b_s.NEXTVAL
105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1

Line 109: FROM OZF_NA_DEDUCTION_RULES_B

105: FROM dual;
106:
107: CURSOR c_id_exists (l_id IN NUMBER) IS
108: SELECT 1
109: FROM OZF_NA_DEDUCTION_RULES_B
110: WHERE na_deduction_rule_id = l_id;
111:
112: l_na_ddn_rule_rec na_ddn_rule_rec_type;
113: BEGIN

Line 333: FROM OZF_NA_DEDUCTION_RULES_B

329:
330:
331: CURSOR c_get_na_ddn_rule(na_deduction_rule_id NUMBER) IS
332: SELECT *
333: FROM OZF_NA_DEDUCTION_RULES_B
334: WHERE na_deduction_rule_id = p_na_ddn_rule_rec.na_deduction_rule_id;
335: -- Hint: Developer need to provide Where clause
336:
337:

Line 814: 'ozf_na_deduction_rules_b',

810: IF p_validation_mode = JTF_PLSQL_API.g_create
811: AND p_na_ddn_rule_rec.na_deduction_rule_id IS NOT NULL
812: THEN
813: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
814: 'ozf_na_deduction_rules_b',
815: 'na_deduction_rule_id = ''' || p_na_ddn_rule_rec.na_deduction_rule_id ||''''
816: );
817: END IF;
818:

Line 1016: FROM ozf_na_deduction_rules_b

1012: l_return_status VARCHAR2(1);
1013:
1014: CURSOR c_complete IS
1015: SELECT *
1016: FROM ozf_na_deduction_rules_b
1017: WHERE na_deduction_rule_id = p_na_ddn_rule_rec.na_deduction_rule_id;
1018: l_na_ddn_rule_rec c_complete%ROWTYPE;
1019: BEGIN
1020: x_complete_rec := p_na_ddn_rule_rec;