APPS.PAY_CA_YEER_PKG dependencies on PER_PEOPLE_F

Line 3384: The is because of the date join on the table per_people_f. If there

3380:
3381: /* For bug 5703506, added DISTINCT to the query. Also had to added the
3382: person_name in the select and other columns in select in the order by.
3383:
3384: The is because of the date join on the table per_people_f. If there
3385: are date track records in that table there will be multiple records */
3386:
3387: cursor cur_asg_act (cp_pactid in number) is
3388: select DISTINCT

Line 3529: l_last_name per_people_f.last_name%TYPE;

3525: l_person_id varchar2(30);
3526: l_action_status varchar2(1);
3527: i number(3);
3528:
3529: l_last_name per_people_f.last_name%TYPE;
3530: l_first_name per_people_f.first_name%TYPE;
3531: l_middle_names per_people_f.middle_names%TYPE;
3532:
3533: begin

Line 3530: l_first_name per_people_f.first_name%TYPE;

3526: l_action_status varchar2(1);
3527: i number(3);
3528:
3529: l_last_name per_people_f.last_name%TYPE;
3530: l_first_name per_people_f.first_name%TYPE;
3531: l_middle_names per_people_f.middle_names%TYPE;
3532:
3533: begin
3534: open cur_pay_act;

Line 3531: l_middle_names per_people_f.middle_names%TYPE;

3527: i number(3);
3528:
3529: l_last_name per_people_f.last_name%TYPE;
3530: l_first_name per_people_f.first_name%TYPE;
3531: l_middle_names per_people_f.middle_names%TYPE;
3532:
3533: begin
3534: open cur_pay_act;
3535: loop