APPS.HR_PAY_BASIS dependencies on PER_PAY_BASES

Line 14: PER_PAY_BASES

10:
11: Description : This package declares procedures required to
12: INSERT, UPDATE and DELETE pay bases:
13:
14: PER_PAY_BASES
15: Change List
16: -----------
17:
18: Version Date Author ER/CR No. Description of Change

Line 46: select per_pay_bases_s.nextval

42: --
43: Begin
44: hr_utility.set_location('hr_pay_basis.generate_unique_id',1);
45: Begin
46: select per_pay_bases_s.nextval
47: into v_pay_basis_id
48: from sys.dual;
49: --
50: exception

Line 83: INSERT INTO PER_PAY_BASES(pay_basis_id,

79: p_pay_basis_id := generate_unique_id;
80: --
81: -- insert row
82: --
83: INSERT INTO PER_PAY_BASES(pay_basis_id,
84: business_group_id,
85: name,
86: pay_basis,
87: input_value_id,

Line 139: from per_pay_bases

135: INTO duplicate
136: FROM sys.dual
137: WHERE EXISTS
138: (select 'Y'
139: from per_pay_bases
140: where upper(p_name) = upper(name)
141: and business_group_id + 0 = p_business_group_id
142: and (p_row_id <> rowid
143: or p_row_id is null)

Line 182: from per_pay_bases

178: INTO duplicate
179: FROM sys.dual
180: WHERE EXISTS
181: (select 'Y'
182: from per_pay_bases
183: where input_value_id = p_input_value_id
184: and nvl(p_rate_id,-1) = nvl(rate_id,-1)
185: and p_business_group_id = business_group_id
186: and (p_row_id <> rowid

Line 227: from per_pay_bases ppb,

223: INTO v_validation_chk
224: FROM sys.dual
225: WHERE EXISTS
226: (select 'Y'
227: from per_pay_bases ppb,
228: pay_input_values_f piv
229: where piv.element_type_id = p_element_type_id
230: and ppb.input_value_id = piv.input_value_id
231: and (p_row_id <> ppb.rowid

Line 562: from per_pay_bases

558: v_pay_basis VARCHAR2 (30);
559: v_input_value_id NUMBER;
560: --
561: CURSOR C IS SELECT pay_basis, input_value_id
562: from per_pay_bases
563: where rowid = p_row_id;
564:
565: --
566: Begin