APPS.PAY_PBD_BUS dependencies on PAY_BALANCE_DIMENSIONS

Line 531: from pay_balance_dimensions dim

527: cursor csr_chk_bal_dim_id_u(p_leg_code varchar2
528: ,p_bg_id number)
529: is
530: select 1
531: from pay_balance_dimensions dim
532: where dim.balance_dimension_id = p_balance_dimension_id
533: and ((dim.business_group_id is not null
534: and dim.business_group_id = p_bg_id)
535: or (dim.legislation_code is not null

Line 543: from pay_balance_dimensions dim

539: --
540: cursor csr_chk_bal_dim_id_s(p_leg_code varchar2)
541: is
542: select 1
543: from pay_balance_dimensions dim
544: where dim.balance_dimension_id = p_balance_dimension_id
545: and dim.business_group_id is null
546: and ((dim.legislation_code is not null
547: and dim.legislation_code = p_leg_code)

Line 553: from pay_balance_dimensions dim

549: --
550: cursor csr_chk_bal_dim_id_g
551: is
552: select 1
553: from pay_balance_dimensions dim
554: where dim.balance_dimension_id = p_balance_dimension_id
555: and dim.business_group_id is null
556: and dim.legislation_code is null;
557: --