DBA Data[Home] [Help]

APPS.HR_UPLOAD_PROPOSAL_API dependencies on PAY_ELEMENT_TYPES_F

Line 847: l_element_type_id pay_element_types_f.element_type_id%TYPE;

843: -- elements
844: --
845: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
846:
847: l_element_type_id pay_element_types_f.element_type_id%TYPE;
848: l_input_value_id pay_input_values_f.input_value_id%TYPE;
849: l_element_link_id pay_element_links_f.element_link_id%TYPE;
850: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
851: l_trunc_date date := p_change_date;

Line 875: pay_element_types_f pet,

871: cursor csr_get_element_detail is
872: select pet.element_type_id,
873: piv.input_value_id
874: from
875: pay_element_types_f pet,
876: pay_input_values_f piv,
877: per_pay_bases ppb,
878: per_all_assignments_f asg
879: