60: IS
61: SELECT fs.varchar2_value fs_value, allo.number_value allo_value,
62: aa.number_value aa_value, ex.varchar2_value ex_value,
63: lnd.varchar2_value lnd_value
64: FROM hr_api_transaction_values fs,
65: hr_api_transaction_values allo,
66: hr_api_transaction_values aa,
67: hr_api_transaction_values ex,
68: hr_api_transaction_values lnd
61: SELECT fs.varchar2_value fs_value, allo.number_value allo_value,
62: aa.number_value aa_value, ex.varchar2_value ex_value,
63: lnd.varchar2_value lnd_value
64: FROM hr_api_transaction_values fs,
65: hr_api_transaction_values allo,
66: hr_api_transaction_values aa,
67: hr_api_transaction_values ex,
68: hr_api_transaction_values lnd
69: WHERE fs.transaction_step_id = cp_transaction_step_id
62: aa.number_value aa_value, ex.varchar2_value ex_value,
63: lnd.varchar2_value lnd_value
64: FROM hr_api_transaction_values fs,
65: hr_api_transaction_values allo,
66: hr_api_transaction_values aa,
67: hr_api_transaction_values ex,
68: hr_api_transaction_values lnd
69: WHERE fs.transaction_step_id = cp_transaction_step_id
70: AND fs.NAME = 'P_FILING_STATUS'
63: lnd.varchar2_value lnd_value
64: FROM hr_api_transaction_values fs,
65: hr_api_transaction_values allo,
66: hr_api_transaction_values aa,
67: hr_api_transaction_values ex,
68: hr_api_transaction_values lnd
69: WHERE fs.transaction_step_id = cp_transaction_step_id
70: AND fs.NAME = 'P_FILING_STATUS'
71: AND allo.transaction_step_id = fs.transaction_step_id
64: FROM hr_api_transaction_values fs,
65: hr_api_transaction_values allo,
66: hr_api_transaction_values aa,
67: hr_api_transaction_values ex,
68: hr_api_transaction_values lnd
69: WHERE fs.transaction_step_id = cp_transaction_step_id
70: AND fs.NAME = 'P_FILING_STATUS'
71: AND allo.transaction_step_id = fs.transaction_step_id
72: AND allo.NAME = 'P_ALLOWANCES'