APPS.PAY_US_ACTION_ARCH dependencies on PAY_ACTION_PARAMETERS

Line 1130: from pay_action_parameters

1126: order by 1 ;
1127:
1128: cursor c_get_act_param is
1129: select parameter_value
1130: from pay_action_parameters
1131: where parameter_name = 'INIT_PAY_ARCHIVE';
1132:
1133: /* Bug 8768738 Fix */
1134: l_payroll_id NUMBER;

Line 6003: FROM pay_action_parameters

5999:
6000: /*Added for Bug#9872952*/
6001: CURSOR c_get_wage_acc_flag IS
6002: SELECT parameter_value
6003: FROM pay_action_parameters
6004: WHERE parameter_name = 'WAGE_ACCUMULATION_ENABLED';
6005:
6006: ln_wage_exempt VARCHAR2(1) := 'N';
6007: lv_profile_value VARCHAR2(1) := 'N';

Line 6398: from pay_action_parameters

6394: and pus.business_group_id = p_business_group_id;
6395:
6396: cursor csr_action_param IS
6397: select parameter_value
6398: from pay_action_parameters
6399: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
6400:
6401: cursor jur ( ass_act_id number, ele_type_id number, date_ear date ) IS
6402: select prrv.result_value

Line 6512: lv_act_param pay_action_parameters.parameter_value%TYPE;

6508: l_print_county_name varchar2(1);
6509: l_def_bal_id number;
6510: l_cnty_name varchar2(240);
6511: lv_garn_arch VARCHAR2(10);
6512: lv_act_param pay_action_parameters.parameter_value%TYPE;
6513: lb_use_new_arch boolean;
6514: lv_procedure_name VARCHAR2(100) := '.get_attachment_number';
6515: lv_error_message VARCHAR2(200);
6516: ln_step NUMBER;