APPS.PAY_CA_YEER_PKG dependencies on PER_PEOPLE_F

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

3843:
3844: /* For bug 5703506, added DISTINCT to the query. Also had to added the
3845: person_name in the select and other columns in select in the order by.
3846:
3847: The is because of the date join on the table per_people_f. If there
3848: are date track records in that table there will be multiple records */
3849:
3850: cursor cur_asg_act (cp_pactid in number) is
3851: select DISTINCT

Line 4021: l_last_name per_people_f.last_name%TYPE;

4017: l_person_id varchar2(30);
4018: l_action_status varchar2(1);
4019: i number(3);
4020:
4021: l_last_name per_people_f.last_name%TYPE;
4022: l_first_name per_people_f.first_name%TYPE;
4023: l_middle_names per_people_f.middle_names%TYPE;
4024: /* Bug 13542043 */
4025: l_cpp_election_date date;

Line 4022: l_first_name per_people_f.first_name%TYPE;

4018: l_action_status varchar2(1);
4019: i number(3);
4020:
4021: l_last_name per_people_f.last_name%TYPE;
4022: l_first_name per_people_f.first_name%TYPE;
4023: l_middle_names per_people_f.middle_names%TYPE;
4024: /* Bug 13542043 */
4025: l_cpp_election_date date;
4026: l_cpp_revocation_date date;

Line 4023: l_middle_names per_people_f.middle_names%TYPE;

4019: i number(3);
4020:
4021: l_last_name per_people_f.last_name%TYPE;
4022: l_first_name per_people_f.first_name%TYPE;
4023: l_middle_names per_people_f.middle_names%TYPE;
4024: /* Bug 13542043 */
4025: l_cpp_election_date date;
4026: l_cpp_revocation_date date;
4027: