DBA Data[Home] [Help]

APPS.PAY_PBD_BUS dependencies on PAY_BALANCE_CATEGORIES_F

Line 369: from pay_balance_categories_f pbc

365: cursor csr_chk_bal_cat_id_u(p_leg_code varchar2
366: ,p_bg_id number)
367: is
368: select 1
369: from pay_balance_categories_f pbc
370: where pbc.balance_category_id = p_balance_category_id
371: and ((pbc.business_group_id is not null
372: and pbc.business_group_id = p_bg_id)
373: or (pbc.legislation_code is not null

Line 381: from pay_balance_categories_f pbc

377: --
378: cursor csr_chk_bal_cat_id_s(p_leg_code varchar2)
379: is
380: select 1
381: from pay_balance_categories_f pbc
382: where pbc.balance_category_id = p_balance_category_id
383: and pbc.business_group_id is null
384: and ((pbc.legislation_code is not null
385: and pbc.legislation_code = p_leg_code)

Line 391: from pay_balance_categories_f pbc

387: --
388: cursor csr_chk_bal_cat_id_g
389: is
390: select 1
391: from pay_balance_categories_f pbc
392: where pbc.balance_category_id = p_balance_category_id
393: and pbc.business_group_id is null
394: and pbc.legislation_code is null;
395: --