DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PAY_CONSOLIDATION_SETS

Line 879: from pay_consolidation_sets cs

875: --
876: -- Get the consolidation_set_id for the specified consolidation set
877: select cs.consolidation_set_id
878: into v_consolidation_set_id
879: from pay_consolidation_sets cs
880: where upper(cs.consolidation_set_name) = upper(p_consolidation_set_name)
881: and cs.business_group_id + 0 = v_business_group_id;
882: --
883: -- Do not need to specify a default payment method when

Line 1014: select pay_consolidation_sets_s.nextval,

1010: --
1011: -- Select the sequence number for the consolidation set. This can then be
1012: -- passed back via the function for later use. Get the business_group_id for
1013: -- the business group.
1014: select pay_consolidation_sets_s.nextval,
1015: business_group_id
1016: into v_consolidation_set_id,
1017: v_business_group_id
1018: from per_business_groups

Line 1021: insert into pay_consolidation_sets

1017: v_business_group_id
1018: from per_business_groups
1019: where name = p_business_group_name;
1020: --
1021: insert into pay_consolidation_sets
1022: (CONSOLIDATION_SET_ID,
1023: BUSINESS_GROUP_ID,
1024: CONSOLIDATION_SET_NAME,
1025: COMMENTS,