DBA Data[Home] [Help]

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1806: FROM pay_element_type_extra_info petei

1802:
1803: CURSOR get_simulation_name(cp_element_type_id NUMBER)
1804: IS
1805: SELECT SUBSTR(petei.eei_information18,1,80)
1806: FROM pay_element_type_extra_info petei
1807: WHERE petei.element_type_id = cp_element_type_id
1808: AND petei.eei_information18 IS NOT NULL;
1809:
1810: lv_procedure_name VARCHAR2(100) := '.populate_elements';

Line 2773: FROM pay_element_type_extra_info petei

2769:
2770: CURSOR get_simulation_name(cp_element_type_id NUMBER)
2771: IS
2772: SELECT petei.eei_information18
2773: FROM pay_element_type_extra_info petei
2774: WHERE petei.element_type_id = cp_element_type_id
2775: AND petei.eei_information18 IS NOT NULL;
2776:
2777: lv_procedure_name VARCHAR2(100) := '.populate_emp_hours_by_rate';

Line 4802: FROM pay_element_type_extra_info eit,

4798: pel.element_link_id,
4799: pel.location_id,
4800: ld_effective_date,
4801: p_assignment_id
4802: FROM pay_element_type_extra_info eit,
4803: pay_element_types_f pet,
4804: pay_element_types_f_tl petl,
4805: pay_element_classifications pec,
4806: pay_input_values_f piv,