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 530: ,pay_element_types_f pet

526: --
527: SELECT pec.classification_name
528: INTO l_classification
529: FROM pay_element_classifications pec
530: ,pay_element_types_f pet
531: WHERE pet.element_type_id = l_element_type_id
532: AND pec.classification_id = pet.classification_id
533: AND l_report_date BETWEEN pet.effective_start_date
534: AND pet.effective_end_date;

Line 775: FROM pay_element_types_f et

771: CURSOR csr_ELEMENT
772: (p_business_group_id IN NUMBER
773: ,p_element_name IN VARCHAR2) IS
774: SELECT et.element_type_id
775: FROM pay_element_types_f et
776: WHERE et.element_name = p_element_name
777: 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));
778: --
779: l_element_rec csr_ELEMENT%ROWTYPE;

Line 2053: ,pay_element_types_f petf

2049: ,pay_payroll_actions ppa
2050: ,pay_run_results rr
2051: ,pay_run_result_values rrv
2052: ,pay_input_values_f pivf
2053: ,pay_element_types_f petf
2054: ,pay_user_tables t
2055: ,pay_user_rows_f r
2056: WHERE ppa.business_group_id = p_business_group_id
2057: AND ppa.action_type IN ('R','Q','I','B')

Line 2114: ,pay_element_types_f petf

2110: ,pay_payroll_actions ppa
2111: ,pay_run_results rr
2112: ,pay_run_result_values rrv
2113: ,pay_input_values_f pivf
2114: ,pay_element_types_f petf
2115: ,pay_user_tables t
2116: ,pay_user_rows_f r
2117: WHERE ppa.business_group_id = p_business_group_id
2118: AND ppa.action_type IN ('R','Q','I','B')

Line 2180: l_element_type_id pay_element_Types_f.element_type_id%TYPE;

2176: l_ovn NUMBER;
2177: l_amount NUMBER;
2178: l_rr_id NUMBER := -1;
2179: l_classification_id pay_element_classifications.classification_id%TYPE;
2180: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2181: l_element_name pay_element_types_f.element_name%TYPE;
2182: rec_613_616_details csr_613_616_details%ROWTYPE;
2183: l_seaman_status VARCHAR2(2);
2184: l_Travel_Ref VARCHAR2(60);

Line 2181: l_element_name pay_element_types_f.element_name%TYPE;

2177: l_amount NUMBER;
2178: l_rr_id NUMBER := -1;
2179: l_classification_id pay_element_classifications.classification_id%TYPE;
2180: l_element_type_id pay_element_Types_f.element_type_id%TYPE;
2181: l_element_name pay_element_types_f.element_name%TYPE;
2182: rec_613_616_details csr_613_616_details%ROWTYPE;
2183: l_seaman_status VARCHAR2(2);
2184: l_Travel_Ref VARCHAR2(60);
2185: l_Pay_Value NUMBER;