APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on HR_API_TRANSACTION_VALUES

Line 60: FROM hr_api_transaction_values fs,

56: IS
57: SELECT fs.varchar2_value fs_value, allo.number_value allo_value,
58: aa.number_value aa_value, ex.varchar2_value ex_value,
59: lnd.varchar2_value lnd_value
60: FROM hr_api_transaction_values fs,
61: hr_api_transaction_values allo,
62: hr_api_transaction_values aa,
63: hr_api_transaction_values ex,
64: hr_api_transaction_values lnd

Line 61: hr_api_transaction_values allo,

57: SELECT fs.varchar2_value fs_value, allo.number_value allo_value,
58: aa.number_value aa_value, ex.varchar2_value ex_value,
59: lnd.varchar2_value lnd_value
60: FROM hr_api_transaction_values fs,
61: hr_api_transaction_values allo,
62: hr_api_transaction_values aa,
63: hr_api_transaction_values ex,
64: hr_api_transaction_values lnd
65: WHERE fs.transaction_step_id = cp_transaction_step_id

Line 62: hr_api_transaction_values aa,

58: aa.number_value aa_value, ex.varchar2_value ex_value,
59: lnd.varchar2_value lnd_value
60: FROM hr_api_transaction_values fs,
61: hr_api_transaction_values allo,
62: hr_api_transaction_values aa,
63: hr_api_transaction_values ex,
64: hr_api_transaction_values lnd
65: WHERE fs.transaction_step_id = cp_transaction_step_id
66: AND fs.NAME = 'P_FILING_STATUS'

Line 63: hr_api_transaction_values ex,

59: lnd.varchar2_value lnd_value
60: FROM hr_api_transaction_values fs,
61: hr_api_transaction_values allo,
62: hr_api_transaction_values aa,
63: hr_api_transaction_values ex,
64: hr_api_transaction_values lnd
65: WHERE fs.transaction_step_id = cp_transaction_step_id
66: AND fs.NAME = 'P_FILING_STATUS'
67: AND allo.transaction_step_id = fs.transaction_step_id

Line 64: hr_api_transaction_values lnd

60: FROM hr_api_transaction_values fs,
61: hr_api_transaction_values allo,
62: hr_api_transaction_values aa,
63: hr_api_transaction_values ex,
64: hr_api_transaction_values lnd
65: WHERE fs.transaction_step_id = cp_transaction_step_id
66: AND fs.NAME = 'P_FILING_STATUS'
67: AND allo.transaction_step_id = fs.transaction_step_id
68: AND allo.NAME = 'P_ALLOWANCES'