DBA Data[Home] [Help]

APPS.PER_FR_D2_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 1171: per_person_type_usages_f 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
1174: and p.person_id = a.person_id
1175: and c.contract_id(+) = a.contract_id

Line 1219: from per_person_type_usages_f pptu,

1215: l_ptu_delim varchar2(10);
1216: --
1217: cursor csr_get_person_type_usages is
1218: select ppttl.user_person_type
1219: from per_person_type_usages_f pptu,
1220: per_person_types_tl ppttl
1221: where pptu.person_id = l_person_id
1222: and ppttl.person_type_id = pptu.person_type_id
1223: and p_start_date between pptu.effective_start_date