APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_API_TRANSACTION_VALUES

Line 1259: from hr_api_transaction_values hatv

1255: -- Cursor to detect phone type transaction data.
1256: cursor csr_hatv(cv_transaction_step_id in number,
1257: cv_name in varchar2) is
1258: select hatv.number_value
1259: from hr_api_transaction_values hatv
1260: where hatv.transaction_step_id = cv_transaction_step_id
1261: and hatv.name = cv_name;
1262: --
1263: l_trans_step_id number default null;

Line 1447: from hr_api_transaction_values hatv

1443: -- Cursor to detect phone type transaction data.
1444: cursor csr_hatv(cv_transaction_step_id in number,
1445: cv_name in varchar2) is
1446: select hatv.number_value
1447: from hr_api_transaction_values hatv
1448: where hatv.transaction_step_id = cv_transaction_step_id
1449: and hatv.name = cv_name;
1450: --
1451: l_trans_step_id number default null;

Line 1687: from hr_api_transaction_values hatv

1683: -- Cursor to detect phone type transaction data.
1684: cursor csr_hatv(cv_transaction_step_id in number,
1685: cv_name in varchar2) is
1686: select hatv.number_value
1687: from hr_api_transaction_values hatv
1688: where hatv.transaction_step_id = cv_transaction_step_id
1689: and hatv.name = cv_name;
1690: --
1691: l_trans_step_id number default null;