DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_ELEMENT_TYPES_F

Line 432: l_element_name pay_element_types_f.element_name%TYPE;

428: l_spp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
429: l_spp_birth_id pay_defined_balances.defined_balance_id%TYPE;
430: l_aspp_adopt_id pay_defined_balances.defined_balance_id%TYPE;
431: L_ASPP_BIRTH_ID PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
432: l_element_name pay_element_types_f.element_name%TYPE;
433: l_eff_date date;
434: l_rec_rate number;
435: l_nic_rate number;
436: l_payroll_id number;

Line 503: select element_name into l_element_name from pay_element_types_f where element_type_id = p_element_type_id

499: fnd_file.put_line(fnd_file.LOG,'Full');
500: p_rec_amount := p_amount;
501: begin
502: -- calculate the NIC value from the PTD value
503: select element_name into l_element_name from pay_element_types_f where element_type_id = p_element_type_id
504: and legislation_code = 'GB' and
505: l_eff_date between effective_start_date and effective_end_date;
506:
507: if l_element_name = 'Statutory Maternity Pay' then