APPS.PAY_GBE_BUS dependencies on PAY_BALANCE_TYPES

Line 513: -- the balance type id exists in pay_balance_types.

509: -- ----------------------------------------------------------------------------
510: --
511: -- Description
512: -- This procedure is used to check that for the row being updated or inserted,
513: -- the balance type id exists in pay_balance_types.
514: --
515: -- Pre Conditions
516: -- None.
517: --

Line 538: -- It should exist on pay_balance_types table.

534: l_exists number;
535: l_proc varchar2(72) := g_package||'chk_bal_type_id ';
536: --
537: -- Cursor to check a valid BALANCE_TYPE_ID being inserted.
538: -- It should exist on pay_balance_types table.
539: --
540: cursor C1 is
541: select balance_type_id
542: from pay_balance_types

Line 542: from pay_balance_types

538: -- It should exist on pay_balance_types table.
539: --
540: cursor C1 is
541: select balance_type_id
542: from pay_balance_types
543: where balance_type_id = p_balance_type_id ;
544: --
545: begin
546: hr_api.mandatory_arg_error

Line 557: -- raise error as FK does not relate to PK in pay_balance_types

553: fetch C1 into l_exists;
554: if C1%notfound then
555: hr_utility.set_location(l_proc, 3);
556: close C1;
557: -- raise error as FK does not relate to PK in pay_balance_types
558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');
559: end if;
560: close C1;
561: hr_utility.set_location('Leaving:'|| l_proc, 10);