DBA Data[Home] [Help]

APPS.HR_UPLOAD_PROPOSAL_API dependencies on PAY_ELEMENT_TYPES_F

Line 817: l_element_type_id pay_element_types_f.element_type_id%TYPE;

813: -- elements
814: --
815: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
816:
817: l_element_type_id pay_element_types_f.element_type_id%TYPE;
818: l_input_value_id pay_input_values_f.input_value_id%TYPE;
819: l_element_link_id pay_element_links_f.element_link_id%TYPE;
820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
821: l_trunc_date date := p_change_date;

Line 845: pay_element_types_f pet,

841: cursor csr_get_element_detail is
842: select pet.element_type_id,
843: piv.input_value_id
844: from
845: pay_element_types_f pet,
846: pay_input_values_f piv,
847: per_pay_bases ppb,
848: per_all_assignments_f asg
849: