DBA Data[Home] [Help]

APPS.PAY_DYN_TRIGGERS dependencies on PER_BUSINESS_GROUPS

Line 413: from per_business_groups

409: else
410: --
411: select business_group_id
412: into l_bus_grp_id
413: from per_business_groups
414: where name = p_business_group;
415: --
416: -- Now setup the payroll.
417: if (p_payroll_name is null) then

Line 529: from per_business_groups

525: else
526: --
527: select business_group_id
528: into l_bus_grp_id
529: from per_business_groups
530: where name = p_business_group;
531: --
532: -- Now setup the payroll.
533: if (p_payroll_name is null) then

Line 721: from per_business_groups

717: --
718: if (p_business_group_name is not null) then
719: select business_group_id
720: into l_business_group_id
721: from per_business_groups
722: where name = p_business_group_name;
723: else
724: l_business_group_id := null;
725: end if;

Line 781: from per_business_groups

777: where upper(payroll_name)= upper(p_payroll_name);
778:
779: cursor csr_sel_bgid(p_business_group_name varchar2) is
780: select business_group_id
781: from per_business_groups
782: where upper(name) = upper(p_business_group_name);
783:
784: l_area_id number;
785: l_business_group_id number;