APPS.PAY_US_GARN_UPGRADE dependencies on PAY_ACTION_PARAMETERS

Line 1470: from pay_action_parameters

1466: and petfi.legislation_code is NULL);
1467:
1468: cursor c_get_curr_arch is
1469: select parameter_value
1470: from pay_action_parameters
1471: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
1472:
1473: l_date_of_mig date;
1474: l_upg_stat varchar2(10);

Line 1501: update pay_action_parameters

1497: open c_get_curr_arch;
1498: fetch c_get_curr_arch into l_curr_arch;
1499: if c_get_curr_arch%FOUND then
1500: if upper(substr(l_curr_arch,1,1)) = 'N' then
1501: update pay_action_parameters
1502: set parameter_value = 'Y'
1503: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
1504: commit;
1505: end if;