eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 251: FROM per_all_assignments_f paaf

247: ,cp_effective_date DATE
248: )
249: IS
250: SELECT payroll_id
251: FROM per_all_assignments_f paaf
252: WHERE paaf.assignment_id=cp_assignment_id
253: AND cp_effective_date BETWEEN paaf.effective_start_date
254: AND paaf.effective_end_date
255: AND paaf.business_group_id =cp_business_group_id

Line 519: per_all_assignments_f asgt ,

515: ,link.element_link_id
516: FROM pay_element_types_f_tl elementtl,
517: pay_element_types_f element,
518: pay_element_links_f link,
519: per_all_assignments_f asgt ,
520: pay_element_type_extra_info pete,
521: per_periods_of_service service_period
522: WHERE element.element_type_id = elementtl.element_type_id
523: AND elementtl.language = USERENV('LANG')

Line 641: per_all_assignments_f asgt ,

637: SELECT element.element_type_id , elementtl.element_name
638: FROM pay_element_types_f_tl elementtl,
639: pay_element_types_f element,
640: pay_element_links_f link,
641: per_all_assignments_f asgt ,
642: pay_element_type_extra_info pete,
643: per_periods_of_service service_period
644: WHERE element.element_type_id = elementtl.element_type_id
645: AND elementtl.language = USERENV('LANG')

Line 869: l_get_pay_det per_all_assignments_f.payroll_id%TYPE;

865:
866:
867: --Variables
868: l_proc varchar2(72) := g_package ||'insert_mileage_claim';
869: l_get_pay_det per_all_assignments_f.payroll_id%TYPE;
870: --l_get_payroll_det c_get_payroll_det%ROWTYPE;
871: --l_get_alt_payroll_det c_get_alt_payroll_det%ROWTYPE;
872: l_get_asg_element_id pay_element_types_f.element_type_id%TYPE;
873: l_get_purp_element_id pay_element_types_f.element_type_id%TYPE;

Line 1858: ,per_all_assignments_f paa

1854: CURSOR c_chk_alloc (cp_registration_number VARCHAR2)
1855: IS
1856: SELECT 'Start_Valid' valid_date
1857: FROM pqp_vehicle_allocations_f pva
1858: ,per_all_assignments_f paa
1859: ,pqp_vehicle_repository_f pvr
1860: WHERE pva.assignment_id=p_assignment_id
1861: AND pvr.registration_number=cp_registration_number
1862: AND pvr.vehicle_repository_id=pva.vehicle_repository_id

Line 1876: ,per_all_assignments_f paa

1872: AND pvr.effective_end_date
1873: UNION
1874: SELECT 'End_Valid' valid_date
1875: FROM pqp_vehicle_allocations_f pva
1876: ,per_all_assignments_f paa
1877: ,pqp_vehicle_repository_f pvr
1878: WHERE pva.assignment_id=p_assignment_id
1879: AND pvr.registration_number=cp_registration_number
1880: AND pvr.vehicle_repository_id=pva.vehicle_repository_id