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_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 91: per_all_people_f per,

87: ,per.per_information14
88: ,per.marital_status
89: ,paf.primary_flag
90: FROM per_all_assignments_f paf,
91: per_all_people_f per,
92: per_periods_of_service pps,
93: per_assignment_status_types ast
94: WHERE paf.assignment_id = c_assignment_id
95: AND paf.person_id = per.person_id

Line 115: per_all_people_f per

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

Line 317: ,c_person_id IN per_all_people_f.person_id%TYPE

313: -- Cursor to chk for other primary assig. within the extract date range.
314: -- =============================================================================
315: CURSOR csr_sec_assg
316: (c_primary_assignment_id IN per_all_assignments_f.assignment_id%TYPE
317: ,c_person_id IN per_all_people_f.person_id%TYPE
318: ,c_effective_date IN Date
319: ,c_extract_start_date IN Date
320: ,c_extract_end_date IN Date ) IS
321: SELECT asg.person_id

Line 2428: (p_person_id IN per_all_people_f.person_id%TYPE

2424: -- Function to check if the assignment being processed has to be reported to
2425: -- ABP as a new hire assignment
2426: --============================================================================
2427: FUNCTION Chk_New_Hire_Asg
2428: (p_person_id IN per_all_people_f.person_id%TYPE
2429: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2430: ,p_business_group_id IN NUMBER
2431: ,p_start_date IN DATE
2432: ,p_end_date IN DATE

Line 2551: FROM per_all_people_f per

2547: RETURN NUMBER IS
2548:
2549: CURSOR get_dob IS
2550: SELECT trunc(date_of_birth)
2551: FROM per_all_people_f per
2552: ,per_all_assignments_f paf
2553: WHERE per.person_id = paf.person_id
2554: AND paf.assignment_id = p_assignment_id
2555: AND p_effective_date BETWEEN per.effective_start_date

Line 5953: l_person_id per_all_people_f.person_id%TYPE;

5949: l_criteria_value Varchar2(2);
5950: l_warning_message Varchar2(2000);
5951: l_error_message Varchar2(2000);
5952: l_asg_type per_all_assignments_f.assignment_type%TYPE;
5953: l_person_id per_all_people_f.person_id%TYPE;
5954: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
5955: BEGIN
5956: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
5957: i := p_business_group_id;

Line 6200: FROM per_all_people_f

6196:
6197: CURSOR cur_get_initials(c_person_id IN Number,
6198: c_date_earned IN Date) IS
6199: SELECT Substr(replace(per_information1,'.',NULL),0,5)
6200: FROM per_all_people_f
6201: WHERE person_id = c_person_id
6202: AND business_group_id = p_business_group_id
6203: AND c_date_earned BETWEEN effective_start_date
6204: AND effective_end_date;

Line 6246: FROM per_all_people_f

6242: CURSOR cur_last_partner_name
6243: (c_person_id IN Number
6244: ,c_date_earned IN Date) IS
6245: SELECT last_name
6246: FROM per_all_people_f
6247: WHERE person_id IN
6248: ( SELECT contact_person_id
6249: FROM per_contact_relationships
6250: WHERE person_id = c_person_id

Line 6263: l_last_partner_name per_all_people_f.last_name%TYPE;

6259: AND business_group_id = p_business_group_id
6260: AND c_date_earned BETWEEN effective_start_date
6261: AND effective_end_date;
6262:
6263: l_last_partner_name per_all_people_f.last_name%TYPE;
6264: l_proc_name Varchar2(150) := g_proc_name ||'Get_Partner_Last_Name';
6265: l_return_value Number :=-1;
6266:
6267: BEGIN

Line 6302: FROM per_all_people_f

6298: ) RETURN Number IS
6299: CURSOR cur_get_gender(c_date_earned IN Date
6300: ,c_business_group_id IN Number) IS
6301: SELECT Decode(sex,'F','V','M') gender
6302: FROM per_all_people_f
6303: WHERE person_id = g_person_id
6304: AND business_group_id = c_business_group_id
6305: AND c_date_earned BETWEEN effective_start_date
6306: AND effective_end_date;

Line 6348: FROM per_all_people_f

6344:
6345: CURSOR cur_partner_prefix
6346: (c_date_earned IN Date) IS
6347: SELECT pre_name_adjunct
6348: FROM per_all_people_f
6349: WHERE person_id IN
6350: (SELECT contact_person_id
6351: FROM per_contact_relationships
6352: WHERE person_id = g_person_id

Line 6403: FROM per_all_people_f

6399: ,p_data_element_value OUT NOCOPY Varchar2) RETURN Number IS
6400:
6401: CURSOR cur_add_fem IS
6402: SELECT per_information13
6403: FROM per_all_people_f
6404: WHERE person_id = g_person_id
6405: AND p_effective_date BETWEEN
6406: effective_start_date AND effective_end_date
6407: AND business_group_id = p_business_group_id

Line 6445: l_per_ee_num per_all_people_f.employee_number%TYPE;

6441: ,p_data_element_value OUT NOCOPY Varchar2
6442: ) RETURN Number IS
6443:
6444: l_proc_name Varchar2(150) := g_proc_name ||'Get_EE_Num';
6445: l_per_ee_num per_all_people_f.employee_number%TYPE;
6446: BEGIN
6447: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6448: IF g_primary_assig.EXISTS(p_assignment_id) THEN
6449: l_per_ee_num := g_primary_assig(p_assignment_id).ee_num;

Line 7220: FROM per_all_people_f

7216: 'BE_LIV_TOG',1,
7217: 'REG_PART',1,
7218: 'BE_WID_PENS',4,
7219: NULL) ms_code
7220: FROM per_all_people_f
7221: WHERE person_id = c_person_id
7222: AND business_group_id = p_business_group_id
7223: AND p_effective_date BETWEEN effective_start_date
7224: AND effective_end_date;

Line 7235: l_marital_status per_all_people_f.marital_status%TYPE;

7231: AND NVL(date_to,hr_api.g_eot)
7232: AND style IN('NL','NL_GLB')
7233: AND primary_flag = 'Y';
7234:
7235: l_marital_status per_all_people_f.marital_status%TYPE;
7236: l_native VARCHAR2(1) := 'N';
7237: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Marital_Status';
7238: l_ret_val NUMBER := -1;
7239:

Line 8588: l_person_id per_all_people_f.person_id%TYPE;

8584: l_return_value NUMBER := -1;
8585: l_new_hire NUMBER := 0;
8586: l_balance_amount NUMBER := 0;
8587: l_override_value NUMBER := 0;
8588: l_person_id per_all_people_f.person_id%TYPE;
8589: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8590: l_balance_id pay_balance_types.balance_type_id%TYPE;
8591: l_proc_name VARCHAR2(150) := g_proc_name ||'Record08_Display_Criteria';
8592: l_hire_dt DATE;

Line 12401: l_person_id per_all_people_f.person_id%TYPE;

12397: l_return_value Number := 1;
12398: l_rcd_id Number;
12399: l_mutli_assig Varchar2(50);
12400: l_asg_type per_all_assignments_f.assignment_type%TYPE;
12401: l_person_id per_all_people_f.person_id%TYPE;
12402: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12403: l_effective_date Date;
12404:
12405: BEGIN

Line 14246: l_employee_number per_all_people_f.Employee_number%TYPE;

14242: ) RETURN Number IS
14243:
14244: l_temp_sort_id Varchar2(50);
14245: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
14246: l_employee_number per_all_people_f.Employee_number%TYPE;
14247: l_temp_person_id per_all_people_f.Employee_number%TYPE;
14248: l_return_value Number := -1;
14249: l_employer_number Number;
14250: l_asg_seq_num Varchar2(2);

Line 14247: l_temp_person_id per_all_people_f.Employee_number%TYPE;

14243:
14244: l_temp_sort_id Varchar2(50);
14245: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
14246: l_employee_number per_all_people_f.Employee_number%TYPE;
14247: l_temp_person_id per_all_people_f.Employee_number%TYPE;
14248: l_return_value Number := -1;
14249: l_employer_number Number;
14250: l_asg_seq_num Varchar2(2);
14251:

Line 14354: l_last_name per_all_people_f.last_name%TYPE;

14350: l_effective_date Date;
14351: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
14352: l_record_num Varchar2(20);
14353: l_return_value Varchar2(2);
14354: l_last_name per_all_people_f.last_name%TYPE;
14355: l_dob VARCHAR2(8);
14356: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14357: l_national_ident per_all_people_f.national_identifier%TYPE;
14358:

Line 14356: l_prefix per_all_people_f.pre_name_adjunct%TYPE;

14352: l_record_num Varchar2(20);
14353: l_return_value Varchar2(2);
14354: l_last_name per_all_people_f.last_name%TYPE;
14355: l_dob VARCHAR2(8);
14356: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14357: l_national_ident per_all_people_f.national_identifier%TYPE;
14358:
14359: CURSOR cur_per_info IS
14360: SELECT national_identifier

Line 14357: l_national_ident per_all_people_f.national_identifier%TYPE;

14353: l_return_value Varchar2(2);
14354: l_last_name per_all_people_f.last_name%TYPE;
14355: l_dob VARCHAR2(8);
14356: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14357: l_national_ident per_all_people_f.national_identifier%TYPE;
14358:
14359: CURSOR cur_per_info IS
14360: SELECT national_identifier
14361: ,UPPER(last_name)

Line 14364: FROM per_all_people_f

14360: SELECT national_identifier
14361: ,UPPER(last_name)
14362: ,UPPER(pre_name_adjunct)
14363: ,TO_CHAR(date_of_birth,'YYYYMMDD')
14364: FROM per_all_people_f
14365: WHERE person_id = p_person_id
14366: AND g_extract_params(p_business_group_id).extract_end_date
14367: BETWEEN effective_start_date AND effective_end_date ;
14368:

Line 14488: l_person_id per_all_people_f.person_id%TYPE;

14484: l_warning_message Varchar2(2000);
14485: l_error_message Varchar2(2000);
14486: l_asg_type per_all_assignments_f.assignment_type%TYPE;
14487: l_main_rec csr_rslt_dtl%ROWTYPE;
14488: l_person_id per_all_people_f.person_id%TYPE;
14489: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
14490: l_mutli_assig Varchar2(150);
14491: BEGIN
14492: