DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_CONSOLIDATION_SETS

Line 854: from pay_consolidation_sets cs

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

Line 989: select pay_consolidation_sets_s.nextval,

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

Line 996: insert into pay_consolidation_sets

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