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.PAY_NO_EOY_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 623: ,pay_element_types_f pet

619: --
620: SELECT pec.classification_name
621: INTO l_classification
622: FROM pay_element_classifications pec
623: ,pay_element_types_f pet
624: WHERE pet.element_type_id = l_element_type_id
625: AND pec.classification_id = pet.classification_id
626: AND l_report_date BETWEEN pet.effective_start_date
627: AND pet.effective_end_date;

Line 868: FROM pay_element_types_f et

864: CURSOR csr_ELEMENT
865: (p_business_group_id IN NUMBER
866: ,p_element_name IN VARCHAR2) IS
867: SELECT et.element_type_id
868: FROM pay_element_types_f et
869: WHERE et.element_name = p_element_name
870: AND ((et.business_group_id IS NULL AND et.legislation_code = 'NO') OR (et.legislation_code IS NULL AND et.business_group_id = p_business_group_id));
871: --
872: l_element_rec csr_ELEMENT%ROWTYPE;

Line 2297: ,pay_element_types_f petf

2293: ,pay_payroll_actions ppa
2294: ,pay_run_results rr
2295: ,pay_run_result_values rrv
2296: ,pay_input_values_f pivf
2297: ,pay_element_types_f petf
2298: ,pay_user_tables t
2299: ,pay_user_rows_f r
2300: WHERE ppa.business_group_id = p_business_group_id
2301: AND ppa.action_type IN ('R','Q','I','B')

Line 2373: ,pay_element_types_f petf

2369: ,pay_payroll_actions ppa
2370: ,pay_run_results rr
2371: ,pay_run_result_values rrv
2372: ,pay_input_values_f pivf
2373: ,pay_element_types_f petf
2374: ,pay_user_tables t
2375: ,pay_user_rows_f r
2376: WHERE ppa.business_group_id = p_business_group_id
2377: AND ppa.action_type IN ('R','Q','I','B')

Line 2439: l_element_type_id pay_element_Types_f.element_type_id%TYPE;

2435: l_ovn NUMBER;
2436: l_amount NUMBER;
2437: l_rr_id NUMBER := -1;
2438: l_classification_id pay_element_classifications.classification_id%TYPE;
2439: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2440: l_element_name pay_element_types_f.element_name%TYPE;
2441: rec_613_616_details csr_613_616_details%ROWTYPE;
2442: l_seaman_status VARCHAR2(2);
2443: l_Travel_Ref VARCHAR2(60);

Line 2440: l_element_name pay_element_types_f.element_name%TYPE;

2436: l_amount NUMBER;
2437: l_rr_id NUMBER := -1;
2438: l_classification_id pay_element_classifications.classification_id%TYPE;
2439: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2440: l_element_name pay_element_types_f.element_name%TYPE;
2441: rec_613_616_details csr_613_616_details%ROWTYPE;
2442: l_seaman_status VARCHAR2(2);
2443: l_Travel_Ref VARCHAR2(60);
2444: l_Pay_Value NUMBER;