DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PAY_CONSOLIDATION_SETS

Line 856: from pay_consolidation_sets cs

852: --
853: -- Get the consolidation_set_id for the specified consolidation set
854: select cs.consolidation_set_id
855: into v_consolidation_set_id
856: from pay_consolidation_sets cs
857: where upper(cs.consolidation_set_name) = upper(p_consolidation_set_name)
858: and cs.business_group_id + 0 = v_business_group_id;
859: --
860: -- Do not need to specify a default payment method when

Line 991: select pay_consolidation_sets_s.nextval,

987: --
988: -- Select the sequence number for the consolidation set. This can then be
989: -- passed back via the function for later use. Get the business_group_id for
990: -- the business group.
991: select pay_consolidation_sets_s.nextval,
992: business_group_id
993: into v_consolidation_set_id,
994: v_business_group_id
995: from per_business_groups

Line 998: insert into pay_consolidation_sets

994: v_business_group_id
995: from per_business_groups
996: where name = p_business_group_name;
997: --
998: insert into pay_consolidation_sets
999: (CONSOLIDATION_SET_ID,
1000: BUSINESS_GROUP_ID,
1001: CONSOLIDATION_SET_NAME,
1002: COMMENTS,