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 2449: (p_person_id IN per_all_people_f.person_id%TYPE

2445: -- Function to check if the assignment being processed has to be reported to
2446: -- ABP as a new hire assignment
2447: --============================================================================
2448: FUNCTION Chk_New_Hire_Asg
2449: (p_person_id IN per_all_people_f.person_id%TYPE
2450: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2451: ,p_business_group_id IN NUMBER
2452: ,p_start_date IN DATE
2453: ,p_end_date IN DATE

Line 2572: FROM per_all_people_f per

2568: RETURN NUMBER IS
2569:
2570: CURSOR get_dob IS
2571: SELECT trunc(date_of_birth)
2572: FROM per_all_people_f per
2573: ,per_all_assignments_f paf
2574: WHERE per.person_id = paf.person_id
2575: AND paf.assignment_id = p_assignment_id
2576: AND p_effective_date BETWEEN per.effective_start_date

Line 6291: l_person_id per_all_people_f.person_id%TYPE;

6287: l_criteria_value Varchar2(2);
6288: l_warning_message Varchar2(2000);
6289: l_error_message Varchar2(2000);
6290: l_asg_type per_all_assignments_f.assignment_type%TYPE;
6291: l_person_id per_all_people_f.person_id%TYPE;
6292: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6293: BEGIN
6294: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6295: i := p_business_group_id;

Line 6538: FROM per_all_people_f

6534:
6535: CURSOR cur_get_initials(c_person_id IN Number,
6536: c_date_earned IN Date) IS
6537: SELECT Substr(replace(per_information1,'.',NULL),0,5)
6538: FROM per_all_people_f
6539: WHERE person_id = c_person_id
6540: AND business_group_id = p_business_group_id
6541: AND c_date_earned BETWEEN effective_start_date
6542: AND effective_end_date;

Line 6584: FROM per_all_people_f

6580: CURSOR cur_last_partner_name
6581: (c_person_id IN Number
6582: ,c_date_earned IN Date) IS
6583: SELECT last_name
6584: FROM per_all_people_f
6585: WHERE person_id IN
6586: ( SELECT contact_person_id
6587: FROM per_contact_relationships
6588: WHERE person_id = c_person_id

Line 6601: l_last_partner_name per_all_people_f.last_name%TYPE;

6597: AND business_group_id = p_business_group_id
6598: AND c_date_earned BETWEEN effective_start_date
6599: AND effective_end_date;
6600:
6601: l_last_partner_name per_all_people_f.last_name%TYPE;
6602: l_proc_name Varchar2(150) := g_proc_name ||'Get_Partner_Last_Name';
6603: l_return_value Number :=-1;
6604:
6605: BEGIN

Line 6640: FROM per_all_people_f

6636: ) RETURN Number IS
6637: CURSOR cur_get_gender(c_date_earned IN Date
6638: ,c_business_group_id IN Number) IS
6639: SELECT Decode(sex,'F','V','M') gender
6640: FROM per_all_people_f
6641: WHERE person_id = g_person_id
6642: AND business_group_id = c_business_group_id
6643: AND c_date_earned BETWEEN effective_start_date
6644: AND effective_end_date;

Line 6686: FROM per_all_people_f

6682:
6683: CURSOR cur_partner_prefix
6684: (c_date_earned IN Date) IS
6685: SELECT pre_name_adjunct
6686: FROM per_all_people_f
6687: WHERE person_id IN
6688: (SELECT contact_person_id
6689: FROM per_contact_relationships
6690: WHERE person_id = g_person_id

Line 6741: FROM per_all_people_f

6737: ,p_data_element_value OUT NOCOPY Varchar2) RETURN Number IS
6738:
6739: CURSOR cur_add_fem IS
6740: SELECT per_information13
6741: FROM per_all_people_f
6742: WHERE person_id = g_person_id
6743: AND p_effective_date BETWEEN
6744: effective_start_date AND effective_end_date
6745: AND business_group_id = p_business_group_id

Line 6783: l_per_ee_num per_all_people_f.employee_number%TYPE;

6779: ,p_data_element_value OUT NOCOPY Varchar2
6780: ) RETURN Number IS
6781:
6782: l_proc_name Varchar2(150) := g_proc_name ||'Get_EE_Num';
6783: l_per_ee_num per_all_people_f.employee_number%TYPE;
6784: BEGIN
6785: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6786: IF g_primary_assig.EXISTS(p_assignment_id) THEN
6787: l_per_ee_num := g_primary_assig(p_assignment_id).ee_num;

Line 7559: FROM per_all_people_f

7555: 'BE_LIV_TOG',1,
7556: 'REG_PART',1,
7557: 'BE_WID_PENS',4,
7558: NULL) ms_code
7559: FROM per_all_people_f
7560: WHERE person_id = c_person_id
7561: AND business_group_id = p_business_group_id
7562: AND p_effective_date BETWEEN effective_start_date
7563: AND effective_end_date;

Line 7574: l_marital_status per_all_people_f.marital_status%TYPE;

7570: AND NVL(date_to,hr_api.g_eot)
7571: AND style IN('NL','NL_GLB')
7572: AND primary_flag = 'Y';
7573:
7574: l_marital_status per_all_people_f.marital_status%TYPE;
7575: l_native VARCHAR2(1) := 'N';
7576: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Marital_Status';
7577: l_ret_val NUMBER := -1;
7578:

Line 8927: l_person_id per_all_people_f.person_id%TYPE;

8923: l_return_value NUMBER := -1;
8924: l_new_hire NUMBER := 0;
8925: l_balance_amount NUMBER := 0;
8926: l_override_value NUMBER := 0;
8927: l_person_id per_all_people_f.person_id%TYPE;
8928: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
8929: l_balance_id pay_balance_types.balance_type_id%TYPE;
8930: l_proc_name VARCHAR2(150) := g_proc_name ||'Record08_Display_Criteria';
8931: l_hire_dt DATE;

Line 12770: l_person_id per_all_people_f.person_id%TYPE;

12766: l_return_value Number := 1;
12767: l_rcd_id Number;
12768: l_mutli_assig Varchar2(50);
12769: l_asg_type per_all_assignments_f.assignment_type%TYPE;
12770: l_person_id per_all_people_f.person_id%TYPE;
12771: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
12772: l_effective_date Date;
12773:
12774: BEGIN

Line 14615: l_employee_number per_all_people_f.Employee_number%TYPE;

14611: ) RETURN Number IS
14612:
14613: l_temp_sort_id Varchar2(50);
14614: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
14615: l_employee_number per_all_people_f.Employee_number%TYPE;
14616: l_temp_person_id per_all_people_f.Employee_number%TYPE;
14617: l_return_value Number := -1;
14618: l_employer_number Number;
14619: l_asg_seq_num Varchar2(2);

Line 14616: l_temp_person_id per_all_people_f.Employee_number%TYPE;

14612:
14613: l_temp_sort_id Varchar2(50);
14614: l_proc_name Varchar2(150) := g_proc_name ||'Sort_Id_Generator';
14615: l_employee_number per_all_people_f.Employee_number%TYPE;
14616: l_temp_person_id per_all_people_f.Employee_number%TYPE;
14617: l_return_value Number := -1;
14618: l_employer_number Number;
14619: l_asg_seq_num Varchar2(2);
14620:

Line 14731: l_last_name per_all_people_f.last_name%TYPE;

14727: l_effective_date Date;
14728: l_ext_rcd_id ben_ext_rcd.ext_rcd_id%TYPE;
14729: l_record_num Varchar2(20);
14730: l_return_value Varchar2(2);
14731: l_last_name per_all_people_f.last_name%TYPE;
14732: l_dob VARCHAR2(8);
14733: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14734: l_national_ident per_all_people_f.national_identifier%TYPE;
14735:

Line 14733: l_prefix per_all_people_f.pre_name_adjunct%TYPE;

14729: l_record_num Varchar2(20);
14730: l_return_value Varchar2(2);
14731: l_last_name per_all_people_f.last_name%TYPE;
14732: l_dob VARCHAR2(8);
14733: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14734: l_national_ident per_all_people_f.national_identifier%TYPE;
14735:
14736: CURSOR cur_per_info IS
14737: SELECT national_identifier

Line 14734: l_national_ident per_all_people_f.national_identifier%TYPE;

14730: l_return_value Varchar2(2);
14731: l_last_name per_all_people_f.last_name%TYPE;
14732: l_dob VARCHAR2(8);
14733: l_prefix per_all_people_f.pre_name_adjunct%TYPE;
14734: l_national_ident per_all_people_f.national_identifier%TYPE;
14735:
14736: CURSOR cur_per_info IS
14737: SELECT national_identifier
14738: ,UPPER(last_name)

Line 14741: FROM per_all_people_f

14737: SELECT national_identifier
14738: ,UPPER(last_name)
14739: ,UPPER(pre_name_adjunct)
14740: ,TO_CHAR(date_of_birth,'YYYYMMDD')
14741: FROM per_all_people_f
14742: WHERE person_id = p_person_id
14743: AND g_extract_params(p_business_group_id).extract_end_date
14744: BETWEEN effective_start_date AND effective_end_date ;
14745:

Line 14865: l_person_id per_all_people_f.person_id%TYPE;

14861: l_warning_message Varchar2(2000);
14862: l_error_message Varchar2(2000);
14863: l_asg_type per_all_assignments_f.assignment_type%TYPE;
14864: l_main_rec csr_rslt_dtl%ROWTYPE;
14865: l_person_id per_all_people_f.person_id%TYPE;
14866: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
14867: l_mutli_assig Varchar2(150);
14868: BEGIN
14869: