APPS.PAY_DEFINED_BALANCES_PKG dependencies on PAY_BALANCE_ATTRIBUTES

Line 80: from pay_balance_attributes

76: where br.defined_balance_id = p_defined_balance_id;
77: --
78: cursor get_pbas(p_def_bal number) is
79: select balance_attribute_id
80: from pay_balance_attributes
81: where defined_balance_id = p_def_bal;
82: --
83: v_org_pay_meth_id number;
84: v_backpay_set_id number;

Line 329: from pay_balance_attributes

325: ,p_bg number
326: ,p_leg varchar2)
327: is
328: select null
329: from pay_balance_attributes
330: where attribute_id = p_att_id
331: and defined_balance_id = p_def_bal_id
332: and nvl(business_group_id,-1) = nvl(p_bg, -1)
333: and nvl(legislation_code, 'NULL') = nvl(p_leg,'NULL');

Line 336: l_balance_attribute_id pay_balance_attributes.balance_attribute_id%type;

332: and nvl(business_group_id,-1) = nvl(p_bg, -1)
333: and nvl(legislation_code, 'NULL') = nvl(p_leg,'NULL');
334: --
335: l_exists number;
336: l_balance_attribute_id pay_balance_attributes.balance_attribute_id%type;
337: --
338: begin
339: for each_attribute in get_default_attributes(p_balance_dimension_id
340: ,p_balance_category_id