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.PER_CN_EMP_LEG_HOOK dependencies on PER_ALL_PEOPLE_F

Line 562: l_business_group_id per_all_people_f.business_group_id%TYPE;

558: IS
559:
560: --Declare local varialbles
561: l_proc VARCHAR2(72) := g_package||'check_person';
562: l_business_group_id per_all_people_f.business_group_id%TYPE;
563:
564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;

Line 564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;

560: --Declare local varialbles
561: l_proc VARCHAR2(72) := g_package||'check_person';
562: l_business_group_id per_all_people_f.business_group_id%TYPE;
563:
564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;

Line 565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;

561: l_proc VARCHAR2(72) := g_package||'check_person';
562: l_business_group_id per_all_people_f.business_group_id%TYPE;
563:
564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;
569:

Line 566: l_percentage per_all_people_f.per_information12%TYPE;

562: l_business_group_id per_all_people_f.business_group_id%TYPE;
563:
564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;
569:
570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,

Line 567: l_person_type_id per_all_people_f.person_type_id%TYPE;

563:
564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;
569:
570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
571: p_effective_date in DATE) IS

Line 568: l_national_identifier per_all_people_f.national_identifier%TYPE;

564: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
565: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;
569:
570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
571: p_effective_date in DATE) IS
572: SELECT business_group_id

Line 570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,

566: l_percentage per_all_people_f.per_information12%TYPE;
567: l_person_type_id per_all_people_f.person_type_id%TYPE;
568: l_national_identifier per_all_people_f.national_identifier%TYPE;
569:
570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
571: p_effective_date in DATE) IS
572: SELECT business_group_id
573: FROM per_all_people_f pap
574: WHERE pap.person_id = p_person_id

Line 573: FROM per_all_people_f pap

569:
570: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
571: p_effective_date in DATE) IS
572: SELECT business_group_id
573: FROM per_all_people_f pap
574: WHERE pap.person_id = p_person_id
575: AND p_effective_date BETWEEN pap.effective_start_date and pap.effective_end_date;
576: --
577: -- Bug 2900110: Added the segment per_information8 to the list

Line 585: FROM per_all_people_f

581: --
582: -- Bug 2902659: Added national_identifier
583: CURSOR csr_per IS SELECT person_type_id, per_information11, per_information12, nvl(per_information8,'N')
584: ,national_identifier
585: FROM per_all_people_f
586: WHERE person_id = p_person_id
587: AND p_effective_date BETWEEN effective_start_date
588: AND effective_end_date;
589: