DBA Data[Home] [Help]

APPS.PAY_PBD_BUS dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 206: from pay_bal_attribute_definitions bad

202: cursor csr_chk_attribute_id_u(p_leg_code varchar2
203: ,p_bg_id number)
204: is
205: select 1
206: from pay_bal_attribute_definitions bad
207: where bad.attribute_id = p_attribute_id
208: and ((bad.business_group_id is not null
209: and bad.business_group_id = p_bg_id)
210: or (bad.legislation_code is not null

Line 218: from pay_bal_attribute_definitions bad

214: --
215: cursor csr_chk_attribute_id_s(p_leg_code varchar2)
216: is
217: select 1
218: from pay_bal_attribute_definitions bad
219: where bad.attribute_id = p_attribute_id
220: and bad.business_group_id is null
221: and ((bad.legislation_code is not null
222: and bad.legislation_code = p_leg_code)

Line 228: from pay_bal_attribute_definitions bad

224: --
225: cursor csr_chk_attribute_id_g
226: is
227: select 1
228: from pay_bal_attribute_definitions bad
229: where bad.attribute_id = p_attribute_id
230: and bad.business_group_id is null
231: and bad.legislation_code is null;
232: --