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 580: l_business_group_id per_all_people_f.business_group_id%TYPE;

576: IS
577:
578: --Declare local varialbles
579: l_proc VARCHAR2(72) := g_package||'check_person';
580: l_business_group_id per_all_people_f.business_group_id%TYPE;
581:
582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;

Line 582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;

578: --Declare local varialbles
579: l_proc VARCHAR2(72) := g_package||'check_person';
580: l_business_group_id per_all_people_f.business_group_id%TYPE;
581:
582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;

Line 583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;

579: l_proc VARCHAR2(72) := g_package||'check_person';
580: l_business_group_id per_all_people_f.business_group_id%TYPE;
581:
582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;
587:

Line 584: l_percentage per_all_people_f.per_information12%TYPE;

580: l_business_group_id per_all_people_f.business_group_id%TYPE;
581:
582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;
587:
588: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,

Line 585: l_person_type_id per_all_people_f.person_type_id%TYPE;

581:
582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;
587:
588: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
589: p_effective_date in DATE) IS

Line 586: l_national_identifier per_all_people_f.national_identifier%TYPE;

582: l_tax_exemption_indicator per_all_people_f.per_information11%TYPE;
583: l_expatriate_indicator per_all_people_f.per_information8%TYPE;
584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;
587:
588: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
589: p_effective_date in DATE) IS
590: SELECT business_group_id

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

584: l_percentage per_all_people_f.per_information12%TYPE;
585: l_person_type_id per_all_people_f.person_type_id%TYPE;
586: l_national_identifier per_all_people_f.national_identifier%TYPE;
587:
588: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
589: p_effective_date in DATE) IS
590: SELECT business_group_id
591: FROM per_all_people_f pap
592: WHERE pap.person_id = p_person_id

Line 591: FROM per_all_people_f pap

587:
588: CURSOR csr_bg_per (p_person_id per_all_people_f.person_id%type,
589: p_effective_date in DATE) IS
590: SELECT business_group_id
591: FROM per_all_people_f pap
592: WHERE pap.person_id = p_person_id
593: AND p_effective_date BETWEEN pap.effective_start_date and pap.effective_end_date;
594: --
595: -- Bug 2900110: Added the segment per_information8 to the list

Line 603: FROM per_all_people_f

599: --
600: -- Bug 2902659: Added national_identifier
601: CURSOR csr_per IS SELECT person_type_id, per_information11, per_information12, nvl(per_information8,'N')
602: ,national_identifier
603: FROM per_all_people_f
604: WHERE person_id = p_person_id
605: AND p_effective_date BETWEEN effective_start_date
606: AND effective_end_date;
607: