APPS.PAY_CONSOLIDATION_SETS_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 1: PACKAGE BODY PAY_CONSOLIDATION_SETS_PKG as

1: PACKAGE BODY PAY_CONSOLIDATION_SETS_PKG as
2: /* $Header: pycss01t.pkb 115.1 99/07/17 05:55:49 porting ship $ */
3: --
4: procedure get_next_sequence(p_consolidation_set_id in out number) is
5: --

Line 6: cursor c1 is select pay_consolidation_sets_s.nextval

2: /* $Header: pycss01t.pkb 115.1 99/07/17 05:55:49 porting ship $ */
3: --
4: procedure get_next_sequence(p_consolidation_set_id in out number) is
5: --
6: cursor c1 is select pay_consolidation_sets_s.nextval
7: from sys.dual;
8: --
9: begin
10: --

Line 32: from pay_consolidation_sets cs

28: p_business_group_id in number,
29: p_rowid in varchar2) is
30: --
31: cursor csr_name is select null
32: from pay_consolidation_sets cs
33: WHERE UPPER(CS.CONSOLIDATION_SET_NAME) =
34: UPPER(P_CONSOLIDATION_SET_NAME)
35: AND CS.business_group_id + 0 =
36: P_BUSINESS_GROUP_ID

Line 102: END PAY_CONSOLIDATION_SETS_PKG;

98: end if;
99: --
100: end check_delete;
101: --
102: END PAY_CONSOLIDATION_SETS_PKG;