APPS.PAY_CA_MAG_ROE dependencies on FF_USER_ENTITIES

Line 29: from ff_user_entities fue

25: declare
26:
27: cursor cur_user_entity_id is
28: select user_entity_id
29: from ff_user_entities fue
30: where fue.user_entity_name = p_user_entity_name
31: and fue.legislation_code = 'CA';
32:
33: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

Line 33: l_user_entity_id ff_user_entities.user_entity_id%TYPE;

29: from ff_user_entities fue
30: where fue.user_entity_name = p_user_entity_name
31: and fue.legislation_code = 'CA';
32:
33: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
34:
35: begin
36:
37: hr_utility.set_location('func_user_entity_id',1);

Line 114: l_roe_date_uid ff_user_entities.user_entity_id%TYPE;

110: p_start_date date;
111: p_end_date date;
112: p_person_id per_people_f.person_id%TYPE;
113: p_assignment_set number;
114: l_roe_date_uid ff_user_entities.user_entity_id%TYPE;
115: l_roe_asg_id_uid ff_user_entities.user_entity_id%TYPE;
116:
117: begin
118:

Line 115: l_roe_asg_id_uid ff_user_entities.user_entity_id%TYPE;

111: p_end_date date;
112: p_person_id per_people_f.person_id%TYPE;
113: p_assignment_set number;
114: l_roe_date_uid ff_user_entities.user_entity_id%TYPE;
115: l_roe_asg_id_uid ff_user_entities.user_entity_id%TYPE;
116:
117: begin
118:
119: --hr_utility.trace_on(1,'ORACLE');