APPS.PAY_CA_RL1_AMEND_MAG dependencies on PER_PEOPLE_F

Line 73: sbachu 10-Dec-2012 115.23 15972601 Removed per_people_f join condition

69: sbachu 20-Nov-2012 115.20 14701466 RL1 EI, slip number and seq number
70: 115.21 13564765 changes for 2012.
71: sbachu 29-Nov-2012 115.22 13633422 ALL_BOXES_ZERO messages is not
72: required from 2011.
73: sbachu 10-Dec-2012 115.23 15972601 Removed per_people_f join condition
74: in the cursor c_original_slipno.
75: sbachu 19-Dec-2012 115.24 15996999 Added 2012 Certification No.
76: RQ-12-01-011.
77: */

Line 576: from per_people_f

572: AND fc.context_name = 'JURISDICTION_CODE';
573:
574: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
575: select substr(full_name,1,48), employee_number
576: from per_people_f
577: where person_id = cp_person_id
578: order by effective_end_date desc;
579:
580: CURSOR c_get_ue_id(cp_user_name varchar2) IS

Line 634: lv_employee_number per_people_f.employee_number%type;

630: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
631: ln_pre_id_null number;
632: ln_iteration number := 0;
633: lv_flag_count number := 0;
634: lv_employee_number per_people_f.employee_number%type;
635: lv_message varchar2(100):= null;
636: lv_full_name per_people_f.full_name%type;
637: lv_record_name varchar2(100);
638: ln_rl1_amend_flag_ue_id number;

Line 636: lv_full_name per_people_f.full_name%type;

632: ln_iteration number := 0;
633: lv_flag_count number := 0;
634: lv_employee_number per_people_f.employee_number%type;
635: lv_message varchar2(100):= null;
636: lv_full_name per_people_f.full_name%type;
637: lv_record_name varchar2(100);
638: ln_rl1_amend_flag_ue_id number;
639: lv_prov_of_emp varchar2(10);
640: lv_prov_amend_flag varchar2(5);

Line 1518: l_person_id per_people_f.person_id%TYPE;

1514: /* BUG 13567075 sbachu*/
1515: l_FraisGarde NUMBER;
1516: l_DeductionForce NUMBER;
1517:
1518: l_person_id per_people_f.person_id%TYPE;
1519: l_address_line1 per_addresses.address_line1%TYPE;
1520: l_address_line2 per_addresses.address_line2%TYPE;
1521: l_address_line3 per_addresses.address_line3%TYPE;
1522: l_combined_addr VARCHAR2(500);