DBA Data[Home] [Help]

APPS.PER_FR_D2_PKG dependencies on PER_ALL_PEOPLE_F

Line 1169: per_all_people_f p,

1165: l_start_ctr,
1166: l_start_ptu,
1167: l_start_bud
1168: from per_all_assignments_f a,
1169: per_all_people_f p,
1170: per_contracts_f c,
1171: per_person_type_usages_f ptu,
1172: per_assignment_budget_values_f b
1173: where a.assignment_id = p_assignment_id

Line 1214: l_person_id per_all_people_f.person_id%TYPE;

1210: p_start_date in date,
1211: p_end_date in date)
1212: is
1213: i binary_integer;
1214: l_person_id per_all_people_f.person_id%TYPE;
1215: l_ptu_delim varchar2(10);
1216: --
1217: cursor csr_get_person_type_usages is
1218: select ppttl.user_person_type

Line 1273: from per_all_people_f per,

1269: p_block_table(i).asg_full_time_hours,
1270: p_block_table(i).asg_fte_value,
1271: p_block_table(i).asg_type,
1272: l_person_id
1273: from per_all_people_f per,
1274: per_contracts_f ctr,
1275: hr_soft_coding_keyflex scl,
1276: per_all_positions pos,
1277: hr_organization_information org,