APPS.PAY_US_GARN_UPGRADE dependencies on PAY_ACTION_PARAMETERS

Line 1485: from pay_action_parameters

1481: and petfi.legislation_code is NULL);
1482:
1483: cursor c_get_curr_arch is
1484: select parameter_value
1485: from pay_action_parameters
1486: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
1487:
1488: l_date_of_mig date;
1489: l_upg_stat varchar2(10);

Line 1516: update pay_action_parameters

1512: open c_get_curr_arch;
1513: fetch c_get_curr_arch into l_curr_arch;
1514: if c_get_curr_arch%FOUND then
1515: if upper(substr(l_curr_arch,1,1)) = 'N' then
1516: update pay_action_parameters
1517: set parameter_value = 'Y'
1518: where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';
1519: commit;
1520: end if;