eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PDT_BUS dependencies on PER_PERSON_TYPES

Line 677: per_person_types ppt

673: --
674: cursor csr_check_per_type(p_person_id number) is
675: select ptu.person_type_id
676: from per_person_type_usages_f ptu,
677: per_person_types ppt
678: where ptu.person_id = p_person_id
679: and ptu.person_type_id = ppt.person_type_id
680: and ppt.system_person_type in ('EMP','CWK','APL')
681: and ptu.effective_end_date >= p_start_date;

Line 686: per_person_types ppt

682: --
683: cursor csr_check_per_type2(p_person_id number) is
684: select ptu.person_type_id
685: from per_person_type_usages_f ptu,
686: per_person_types ppt
687: where ptu.person_id = p_person_id
688: and ptu.person_type_id = ppt.person_type_id
689: and ppt.system_person_type in ('EMP','CWK','APL')
690: and ptu.effective_start_date > p_start_date

Line 693: per_person_types ppt1

689: and ppt.system_person_type in ('EMP','CWK','APL')
690: and ptu.effective_start_date > p_start_date
691: and not exists (select 1
692: from per_person_type_usages_f ptu1,
693: per_person_types ppt1
694: where ptu.person_type_usage_id = ptu1.person_type_usage_id
695: and ptu1.person_type_id = ppt1.person_type_id
696: and ppt1.system_person_type in ('EMP','CWK','APL')
697: and ptu1.effective_start_date = p_start_date);

Line 843: l_sys_type per_person_types.system_person_type%type;

839: ) is
840: --
841: l_proc varchar2(72) := g_package||'chk_';
842: l_api_updating boolean;
843: l_sys_type per_person_types.system_person_type%type;
844: l_bg_id per_person_types.business_group_id%type;
845: l_active_flag per_person_types.active_flag%type;
846: --
847: cursor csr_check_per_type is

Line 844: l_bg_id per_person_types.business_group_id%type;

840: --
841: l_proc varchar2(72) := g_package||'chk_';
842: l_api_updating boolean;
843: l_sys_type per_person_types.system_person_type%type;
844: l_bg_id per_person_types.business_group_id%type;
845: l_active_flag per_person_types.active_flag%type;
846: --
847: cursor csr_check_per_type is
848: select system_person_type,business_group_id,active_flag

Line 845: l_active_flag per_person_types.active_flag%type;

841: l_proc varchar2(72) := g_package||'chk_';
842: l_api_updating boolean;
843: l_sys_type per_person_types.system_person_type%type;
844: l_bg_id per_person_types.business_group_id%type;
845: l_active_flag per_person_types.active_flag%type;
846: --
847: cursor csr_check_per_type is
848: select system_person_type,business_group_id,active_flag
849: from per_person_types

Line 849: from per_person_types

845: l_active_flag per_person_types.active_flag%type;
846: --
847: cursor csr_check_per_type is
848: select system_person_type,business_group_id,active_flag
849: from per_person_types
850: where person_type_id = p_person_type_id;
851: --
852: begin
853: hr_utility.set_location('Entering:'||l_proc, 10);

Line 1561: l_sys_type per_person_types.system_person_type%type;

1557: ) is
1558: --
1559: l_proc varchar2(72) := g_package||'chk_';
1560: l_api_updating boolean;
1561: l_sys_type per_person_types.system_person_type%type;
1562: l_bg_id per_person_types.business_group_id%type;
1563: l_active_flag per_person_types.active_flag%type;
1564: --
1565: cursor csr_check_per_type is

Line 1562: l_bg_id per_person_types.business_group_id%type;

1558: --
1559: l_proc varchar2(72) := g_package||'chk_';
1560: l_api_updating boolean;
1561: l_sys_type per_person_types.system_person_type%type;
1562: l_bg_id per_person_types.business_group_id%type;
1563: l_active_flag per_person_types.active_flag%type;
1564: --
1565: cursor csr_check_per_type is
1566: select system_person_type,business_group_id,active_flag

Line 1563: l_active_flag per_person_types.active_flag%type;

1559: l_proc varchar2(72) := g_package||'chk_';
1560: l_api_updating boolean;
1561: l_sys_type per_person_types.system_person_type%type;
1562: l_bg_id per_person_types.business_group_id%type;
1563: l_active_flag per_person_types.active_flag%type;
1564: --
1565: cursor csr_check_per_type is
1566: select system_person_type,business_group_id,active_flag
1567: from per_person_types

Line 1567: from per_person_types

1563: l_active_flag per_person_types.active_flag%type;
1564: --
1565: cursor csr_check_per_type is
1566: select system_person_type,business_group_id,active_flag
1567: from per_person_types
1568: where person_type_id = p_leaving_person_type_id;
1569: --
1570: begin
1571: hr_utility.set_location('Entering:'||l_proc, 10);