APPS.PAY_PBA_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 206: from pay_bal_attribute_definitions

202: is
203: select alterable
204: , business_group_id
205: , legislation_code
206: from pay_bal_attribute_definitions
207: where attribute_id = p_att_id;
208: --
209: l_alt pay_bal_attribute_definitions.alterable%type;
210: l_bg pay_bal_attribute_definitions.business_group_id%type;

Line 209: l_alt pay_bal_attribute_definitions.alterable%type;

205: , legislation_code
206: from pay_bal_attribute_definitions
207: where attribute_id = p_att_id;
208: --
209: l_alt pay_bal_attribute_definitions.alterable%type;
210: l_bg pay_bal_attribute_definitions.business_group_id%type;
211: l_leg pay_bal_attribute_definitions.legislation_code%type;
212: l_allow_ins_del boolean;
213: --

Line 210: l_bg pay_bal_attribute_definitions.business_group_id%type;

206: from pay_bal_attribute_definitions
207: where attribute_id = p_att_id;
208: --
209: l_alt pay_bal_attribute_definitions.alterable%type;
210: l_bg pay_bal_attribute_definitions.business_group_id%type;
211: l_leg pay_bal_attribute_definitions.legislation_code%type;
212: l_allow_ins_del boolean;
213: --
214: BEGIN

Line 211: l_leg pay_bal_attribute_definitions.legislation_code%type;

207: where attribute_id = p_att_id;
208: --
209: l_alt pay_bal_attribute_definitions.alterable%type;
210: l_bg pay_bal_attribute_definitions.business_group_id%type;
211: l_leg pay_bal_attribute_definitions.legislation_code%type;
212: l_allow_ins_del boolean;
213: --
214: BEGIN
215: hr_utility.set_location('Entering '||l_proc, 5);

Line 316: from pay_bal_attribute_definitions bad

312: cursor csr_chk_attribute_id_u(p_leg_code varchar2
313: ,p_bg_id number)
314: is
315: select 1
316: from pay_bal_attribute_definitions bad
317: where bad.attribute_id = p_attribute_id
318: and ((bad.business_group_id is not null
319: and bad.business_group_id = p_bg_id)
320: or (bad.legislation_code is not null

Line 328: from pay_bal_attribute_definitions bad

324: --
325: cursor csr_chk_attribute_id_s(p_leg_code varchar2)
326: is
327: select 1
328: from pay_bal_attribute_definitions bad
329: where bad.attribute_id = p_attribute_id
330: and bad.business_group_id is null
331: and ((bad.legislation_code is not null
332: and bad.legislation_code = p_leg_code)

Line 338: from pay_bal_attribute_definitions bad

334: --
335: cursor csr_chk_attribute_id_g
336: is
337: select 1
338: from pay_bal_attribute_definitions bad
339: where bad.attribute_id = p_attribute_id
340: and bad.business_group_id is null
341: and bad.legislation_code is null;
342: --