DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 293: from PER_ALL_ASSIGNMENTS_F

289: l_information_code varchar2(50);
290:
291: cursor get_scl_id is
292: select SOFT_CODING_KEYFLEX_ID
293: from PER_ALL_ASSIGNMENTS_F
294: where assignment_id = p_assignment_id;
295:
296: cursor get_org_id is
297: select ORGANIZATION_ID

Line 298: from PER_ALL_ASSIGNMENTS_F

294: where assignment_id = p_assignment_id;
295:
296: cursor get_org_id is
297: select ORGANIZATION_ID
298: from PER_ALL_ASSIGNMENTS_F
299: where assignment_id = p_assignment_id;
300:
301: cursor get_info_from_scl is
302: select lookups.meaning

Line 689: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,

685:
686: -- function for Norway BIK Company Cars to get vehile information using Vehicle Repository
687:
688: FUNCTION get_vehicle_info
689: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
690: p_date_earned DATE,
691: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
692: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
693: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE