DBA Data[Home] [Help]

APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on HR_API_TRANSACTION_VALUES

Line 64: FROM hr_api_transaction_values fs,

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

Line 65: hr_api_transaction_values allo,

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

Line 66: hr_api_transaction_values aa,

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'

Line 67: hr_api_transaction_values ex,

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

Line 68: hr_api_transaction_values lnd

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'