DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_ACTION_PARAMETERS

Line 315: from pay_action_parameters

311: -- What Wage Attachment Architecture is in use
312:
313: CURSOR csr_action_param IS
314: select parameter_value
315: from pay_action_parameters
316: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
317:
318: -- Fetch data for Old Arch Garn Elements
319: -- Query should return Correct Amount and Attachment Number

Line 450: lv_act_param pay_action_parameters.parameter_value%TYPE;

446: lv_med_ind VARCHAR2(1);
447: ld_payment_date DATE;
448: ln_run_result_id NUMBER;
449: lv_garn_arch VARCHAR2(10);
450: lv_act_param pay_action_parameters.parameter_value%TYPE;
451: lb_use_new_arch BOOLEAN ;
452:
453: begin
454: hr_utility.trace('Entering pay_nacha_tape.get_third_party_details');