APPS.PER_PYP_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 325: FROM pay_element_types_f pet,

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

Line 345: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;

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

Line 1620: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1616: l_ele_max_value pay_input_values_f.max_value%TYPE;
1617: l_link_w_or_e pay_link_input_values_f.warning_or_error%TYPE;
1618: l_link_min_value pay_link_input_values_f.min_value%TYPE;
1619: l_link_max_value pay_link_input_values_f.max_value%TYPE;
1620: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1621: l_pay_basis VARCHAR2(30);
1622: l_grade_basis VARCHAR2(30);
1623: l_annual_salary number;
1624: l_currency_code VARCHAR2(15);

Line 1714: FROM PAY_ELEMENT_TYPES_F PET

1710: , PPB.PAY_BASIS
1711: , PPB.RATE_BASIS
1712: , PET.ELEMENT_TYPE_ID
1713: , PIV.UOM
1714: FROM PAY_ELEMENT_TYPES_F PET
1715: , PAY_INPUT_VALUES_F PIV
1716: , PER_PAY_BASES PPB
1717: --
1718: WHERE PPB.PAY_BASIS_ID=P_PAY_BASIS_ID