APPS.PQP_INI_BAL dependencies on PAY_ELEMENT_TYPES_F

Line 931: from pay_element_types_f

927: IS
928:
929: Cursor c_element_type is
930: select element_type_id
931: from pay_element_types_f
932: where element_name = p_element_name
933: and business_group_id = p_business_group_id
934: and p_effective_date between effective_start_date
935: and effective_end_date;

Line 936: l_element_id pay_element_types_f.element_type_id%TYPE;

932: where element_name = p_element_name
933: and business_group_id = p_business_group_id
934: and p_effective_date between effective_start_date
935: and effective_end_date;
936: l_element_id pay_element_types_f.element_type_id%TYPE;
937: BEGIN
938:
939: Open c_element_type;
940: Fetch c_element_type into l_element_id;

Line 994: l_element_name pay_element_types_f.element_name%TYPE;

990: ,p_entry_value15 IN VARCHAR2
991: )
992: AS
993:
994: l_element_name pay_element_types_f.element_name%TYPE;
995: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
996: l_base_element_type_id pay_element_types_f.element_type_id%TYPE;
997: l_input_val t_input_val;
998: l_element_link_id pay_element_links_f.element_link_id%TYPE;

Line 995: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;

991: )
992: AS
993:
994: l_element_name pay_element_types_f.element_name%TYPE;
995: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
996: l_base_element_type_id pay_element_types_f.element_type_id%TYPE;
997: l_input_val t_input_val;
998: l_element_link_id pay_element_links_f.element_link_id%TYPE;
999: l_row_id VARCHAR2(60);

Line 996: l_base_element_type_id pay_element_types_f.element_type_id%TYPE;

992: AS
993:
994: l_element_name pay_element_types_f.element_name%TYPE;
995: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
996: l_base_element_type_id pay_element_types_f.element_type_id%TYPE;
997: l_input_val t_input_val;
998: l_element_link_id pay_element_links_f.element_link_id%TYPE;
999: l_row_id VARCHAR2(60);
1000: l_effective_start_date DATE;

Line 1521: From pay_element_types_f pet

1517: ,to_number(NULL) Engine_capacity
1518: ,to_char(NULL) Calculation_Method
1519: ,to_number(NULL) Claimed_Mileage
1520: ,to_number(NULL) Actual_Mileage
1521: From pay_element_types_f pet
1522: ,pay_element_type_extra_info petei
1523: ,pay_assignment_actions paa
1524: ,pay_run_results prr
1525: ,pay_payroll_actions ppa