APPS.PER_PYP_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 324: FROM pay_element_types_f pet,

320:
321: CURSOR csr_ele_term_rule(p_assignment_id IN NUMBER
322: ,p_change_date IN DATE) IS
323: SELECT pet.post_termination_rule
324: FROM pay_element_types_f pet,
325: per_all_assignments_f asg,
326: per_pay_bases ppb,
327: pay_input_values_f iv
328: WHERE pet.element_type_id = iv.element_type_id

Line 344: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;

340: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
341: --4073821
342: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
343: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
344: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;
345:
346: l_proc varchar2(72) := g_package||'chk_pay_basis_change_date';
347: --
348: begin

Line 1730: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1726: l_ele_max_value pay_input_values_f.max_value%TYPE;
1727: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1728: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1729: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1730: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1731: l_pay_basis VARCHAR2(30);
1732: l_grade_basis VARCHAR2(30);
1733: l_annual_salary number;
1734: l_currency_code VARCHAR2(15);

Line 1825: FROM PAY_ELEMENT_TYPES_F PET

1821: , PPB.PAY_BASIS
1822: , PPB.RATE_BASIS
1823: , PET.ELEMENT_TYPE_ID
1824: , PIV.UOM
1825: FROM PAY_ELEMENT_TYPES_F PET
1826: , PAY_INPUT_VALUES_F PIV
1827: , PER_PAY_BASES PPB
1828: --
1829: WHERE PPB.PAY_BASIS_ID=P_PAY_BASIS_ID