APPS.PAY_BACKPAY_SETS_PKG dependencies on PAY_BACKPAY_SETS

Line 1: PACKAGE BODY PAY_BACKPAY_SETS_PKG AS

1: PACKAGE BODY PAY_BACKPAY_SETS_PKG AS
2: /* $Header: pybks01t.pkb 115.1 99/07/17 05:45:47 porting ship $ */
3: -----------------------------------------------------------------------------
4: -----------------------------------------------------------------------------
5: procedure check_name_uniqueness(

Line 25: from pay_backpay_sets s

21: into l_null
22: from sys.dual
23: where not exists (
24: select null
25: from pay_backpay_sets s
26: where s.business_group_id + 0 = P_BUS_GRP_ID
27: and s.backpay_set_name = P_SET_NAME
28: and s.backpay_set_id <> P_SET_ID);
29: exception

Line 45: from pay_backpay_sets s

41: into l_null
42: from sys.dual
43: where not exists (
44: select null
45: from pay_backpay_sets s
46: where s.business_group_id + 0 = P_BUS_GRP_ID
47: and s.backpay_set_name = P_SET_NAME);
48: exception
49: when NO_DATA_FOUND then

Line 58: END PAY_BACKPAY_SETS_PKG;

54: end if;
55: --
56: end check_name_uniqueness;
57: -----------------------------------------------------------------------------
58: END PAY_BACKPAY_SETS_PKG;