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

Line 66: per_all_people_f per,

62: ,per.per_information14
63: ,per.marital_status
64: ,paf.primary_flag
65: FROM per_all_assignments_f paf,
66: per_all_people_f per,
67: per_periods_of_service pps,
68: per_assignment_status_types ast
69: WHERE paf.assignment_id = c_assignment_id
70: AND paf.person_id = per.person_id

Line 112: per_all_people_f per

108: ,c_person_id IN Number) IS
109: SELECT paf.organization_id
110: ,paf.payroll_id
111: FROM per_all_assignments_f paf,
112: per_all_people_f per
113: WHERE paf.assignment_id <> c_assignment_id
114: AND paf.person_id = c_person_id
115: AND paf.person_id = per.person_id
116: AND c_effective_date BETWEEN paf.effective_start_date

Line 178: ,c_person_id IN per_all_people_f.person_id%TYPE

174: -- Cursor to chk for other primary assig. within the extract date range.
175: -- =============================================================================
176: CURSOR csr_sec_assg
177: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
178: ,c_person_id IN per_all_people_f.person_id%TYPE
179: ,c_effective_date IN Date
180: ,c_extract_start_date IN Date
181: ,c_extract_end_date IN Date ) IS
182: SELECT asg.person_id

Line 1394: l_person_id per_all_people_f.person_id%TYPE;

1390: l_criteria_value Varchar2(2);
1391: l_warning_message Varchar2(2000);
1392: l_error_message Varchar2(2000);
1393: l_asg_type per_all_assignments_f.assignment_type%TYPE;
1394: l_person_id per_all_people_f.person_id%TYPE;
1395: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1396: BEGIN
1397: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1398: bg_id := p_business_group_id;

Line 1622: l_person_id per_all_people_f.person_id%TYPE;

1618: l_warning_message Varchar2(2000);
1619: l_error_message Varchar2(2000);
1620: l_asg_type per_all_assignments_f.assignment_type %TYPE;
1621: l_main_rec csr_rslt_dtl%ROWTYPE;
1622: l_person_id per_all_people_f.person_id%TYPE;
1623: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1624: l_mutli_assig Varchar2(150);
1625: BEGIN
1626:

Line 3125: FROM per_all_people_f

3121:
3122: CURSOR cur_get_initials(c_person_id IN Number,
3123: c_date_earned IN Date) IS
3124: SELECT Substr(replace(per_information1,'.',NULL),1,5)
3125: FROM per_all_people_f
3126: WHERE person_id = c_person_id
3127: AND business_group_id = p_business_group_id
3128: AND c_date_earned BETWEEN effective_start_date
3129: AND effective_end_date;

Line 3169: FROM per_all_people_f

3165: ) RETURN Number IS
3166: CURSOR cur_get_gender(c_date_earned IN Date
3167: ,c_business_group_id IN Number) IS
3168: SELECT Decode(sex,'F','V','M') gender
3169: FROM per_all_people_f
3170: WHERE person_id = g_person_id
3171: AND business_group_id = c_business_group_id
3172: AND c_date_earned BETWEEN effective_start_date
3173: AND effective_end_date;

Line 3629: l_per_ee_num per_all_people_f.employee_number%TYPE;

3625: ,p_data_element_value OUT NOCOPY Varchar2
3626: ) RETURN Number IS
3627:
3628: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_EE_Num';
3629: l_per_ee_num per_all_people_f.employee_number%TYPE;
3630: l_asg_seq_num VARCHAR2(2);
3631:
3632: BEGIN
3633:

Line 5552: l_employee_number per_all_people_f.Employee_number%TYPE;

5548: ) RETURN Number IS
5549:
5550: l_temp_sort_id Varchar2(50);
5551: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
5552: l_employee_number per_all_people_f.Employee_number%TYPE;
5553: l_temp_person_id per_all_people_f.Employee_number%TYPE;
5554: l_return_value Number := -1;
5555: l_employer_number Number;
5556: l_asg_seq_num Varchar2(2);

Line 5553: l_temp_person_id per_all_people_f.Employee_number%TYPE;

5549:
5550: l_temp_sort_id Varchar2(50);
5551: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
5552: l_employee_number per_all_people_f.Employee_number%TYPE;
5553: l_temp_person_id per_all_people_f.Employee_number%TYPE;
5554: l_return_value Number := -1;
5555: l_employer_number Number;
5556: l_asg_seq_num Varchar2(2);
5557:

Line 6573: l_person_id per_all_people_f.person_id%TYPE;

6569: AND paa.action_status = 'C'
6570: AND ppa.action_type IN ('R', 'Q', 'I', 'B', 'V');
6571:
6572:
6573: l_person_id per_all_people_f.person_id%TYPE;
6574: l_proc_name VARCHAR2(150) := g_proc_name ||'Record010_Display_Criteria';
6575: l_return_value NUMBER :=0;
6576: l_new_asg VARCHAR2(1);
6577: l_prev_pggm_er_num NUMBER;

Line 6649: l_person_id per_all_people_f.person_id%TYPE;

6645: FROM per_all_assignments_f paa
6646: WHERE paa.assignment_id = c_assignment_id
6647: AND paa.business_group_id = c_business_group_id;
6648:
6649: l_person_id per_all_people_f.person_id%TYPE;
6650: l_proc_name Varchar2(150) := g_proc_name ||'Record020_Display_Criteria';
6651: l_return_value Number :=0;
6652: l_term_asg Varchar2(1);
6653: l_rev_asg_dt DATE;

Line 6763: l_person_id per_all_people_f.person_id%TYPE;

6759: AND paa.business_group_id = c_business_group_id
6760: AND paa.assignment_status_type_id=past.assignment_status_type_id
6761: AND past.per_system_status = 'TERM_ASSIGN';
6762:
6763: l_person_id per_all_people_f.person_id%TYPE;
6764: l_proc_name Varchar2(150) := g_proc_name ||'Record030_Display_Criteria';
6765: l_return_value Number :=0;
6766: l_term_asg Varchar2(1);
6767: l_irr_paymnt NUMBER:=0;

Line 6986: l_person_id per_all_people_f.person_id%TYPE;

6982: ORDER by ext_chg_evt_log_id desc;
6983:
6984: l_old_country_code Number;
6985: l_new_country_code Number;
6986: l_person_id per_all_people_f.person_id%TYPE;
6987: l_proc_name Varchar2(150) := g_proc_name ||'Record040_Display_Criteria';
6988: l_return_value Number :=0;
6989: l_chg_addr Varchar2(10);
6990: l_eff_date DATE;