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 PAY_ELEMENT_TYPES_F

Line 104: FROM pay_element_types_f pet

100: ,cp_effective_date DATE
101: )
102: IS
103: SELECT pet.element_type_id
104: FROM pay_element_types_f pet
105: WHERE pet.element_name = cp_element_name
106: AND pet.business_group_id = cp_business_group_id
107: AND cp_effective_date BETWEEN pet.effective_start_date
108: AND pet.effective_end_date;

Line 516: FROM pay_element_types_f_tl elementtl,

512: IS
513: SELECT element.element_type_id
514: , elementtl.element_name
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,

Line 517: pay_element_types_f element,

513: SELECT element.element_type_id
514: , elementtl.element_name
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

Line 638: FROM pay_element_types_f_tl elementtl,

634: ,cp_sl_rate_type VARCHAR2
635: )
636: IS
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,

Line 639: pay_element_types_f element,

635: )
636: IS
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

Line 706: l_validate_mileage_element pay_element_types_f.element_type_id%TYPE;

702:
703:
704: l_proc varchar2(72) := g_package ||'get_elig_mileage_element';
705: l_get_elig_mileage_element c_get_elig_mileage_element%ROWTYPE;
706: l_validate_mileage_element pay_element_types_f.element_type_id%TYPE;
707: BEGIN
708:
709: hr_utility.set_location(l_proc,10);
710: OPEN c_get_elig_mileage_element( p_assignment_id

Line 872: l_get_asg_element_id pay_element_types_f.element_type_id%TYPE;

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;
874: l_get_asg_rate_id VARCHAR2(80);
875: l_get_config_element c_get_config_element%ROWTYPE;
876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;

Line 873: l_get_purp_element_id pay_element_types_f.element_type_id%TYPE;

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;
874: l_get_asg_rate_id VARCHAR2(80);
875: l_get_config_element c_get_config_element%ROWTYPE;
876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;
877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;

Line 876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;

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;
874: l_get_asg_rate_id VARCHAR2(80);
875: l_get_config_element c_get_config_element%ROWTYPE;
876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;
877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;
878: l_get_ele_link c_get_ele_link%ROWTYPE;
879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;

873: l_get_purp_element_id pay_element_types_f.element_type_id%TYPE;
874: l_get_asg_rate_id VARCHAR2(80);
875: l_get_config_element c_get_config_element%ROWTYPE;
876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;
877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;
878: l_get_ele_link c_get_ele_link%ROWTYPE;
879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;

Line 880: l_element_type_id pay_element_types_f.element_type_id%TYPE;

876: l_valid_mileage_element_id pay_element_types_f.element_type_id%TYPE;
877: l_elig_mileage_element_id pay_element_types_f.element_type_id%TYPE;
878: l_get_ele_link c_get_ele_link%ROWTYPE;
879: l_effective_date DATE;
880: l_element_type_id pay_element_types_f.element_type_id%TYPE;
881: l_element_link_id pay_element_links_f.element_link_id%TYPE;
882: l_rates_table_id VARCHAR2(80); --pay_user_tables.user_table_id%TYPE;
883: l_get_element_type_id pqp_configuration_values.pcv_information5%TYPE;
884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;

Line 900: l_purp_element_name pay_element_types_f.element_name%TYPE;

896: l_canonical_ed_dt VARCHAR2(24);
897: l_st_dt DATE;
898: l_ed_dt DATE;
899: l_user_type VARCHAR2(3);
900: l_purp_element_name pay_element_types_f.element_name%TYPE;
901: l_purp_rates_table_id pay_user_tables.user_table_id%TYPE;
902: l_purp_rates_table pay_user_tables.user_table_name%TYPE;
903: l_purp_taxable VARCHAR2(3);
904: l_sliding_rates VARCHAR2(1);

Line 2315: FROM pay_element_types_f pet

2311:
2312: IS
2313: SELECT pet.element_type_id
2314: ,pel.element_link_id
2315: FROM pay_element_types_f pet
2316: ,pay_element_type_extra_info pete
2317: ,pay_element_links_f pel
2318: WHERE pete.eei_information_category='PQP_VEHICLE_MILEAGE_INFO'
2319: AND pet.element_type_id=pete.element_type_id

Line 2478: from pay_element_types_f_tl

2474: --
2475: CURSOR c_get_element_name
2476: IS
2477: select element_name
2478: from pay_element_types_f_tl
2479: where element_type_id = p_field_id;
2480:
2481: --
2482: -- Cursor to fetch the Rates Table Name given the rates table id

Line 2720: FROM pay_element_types_f pet

2716: --is PAYE Taxable is YES.
2717: CURSOR c_get_tax_element_type_id
2718: IS
2719: SELECT DISTINCT pet.element_type_id
2720: FROM pay_element_types_f pet
2721: WHERE pet.element_name = p_element_name||' Taxable'
2722: AND pet.business_group_id=p_business_group_id ;
2723:
2724: CURSOR c_get_gross_pay_bal_name