DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 337: from PER_ALL_ASSIGNMENTS_F

333: l_information_code varchar2(50);
334:
335: cursor get_scl_id is
336: select SOFT_CODING_KEYFLEX_ID
337: from PER_ALL_ASSIGNMENTS_F
338: where assignment_id = p_assignment_id;
339:
340: cursor get_org_id is
341: select ORGANIZATION_ID

Line 342: from PER_ALL_ASSIGNMENTS_F

338: where assignment_id = p_assignment_id;
339:
340: cursor get_org_id is
341: select ORGANIZATION_ID
342: from PER_ALL_ASSIGNMENTS_F
343: where assignment_id = p_assignment_id;
344:
345: cursor get_info_from_scl is
346: select lookups.meaning

Line 756: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,

752:
753: -- function for Norway BIK Company Cars to get vehile information using Vehicle Repository
754:
755: FUNCTION get_vehicle_info
756: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
757: p_date_earned DATE,
758: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
759: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
760: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE