APPS.HR_WORKFLOW_SERVICE dependencies on PER_APPRAISALS

Line 2009: and t.transaction_ref_table <> 'PER_APPRAISALS'

2005: nvl(item_key,hr_workflow_service.getItemKey(t.transaction_id)) item_key
2006: from hr_api_transactions t
2007: where t.last_update_date <= sysdate - c_transaction_age
2008: and t.status not in ('Y', 'YS','W')
2009: and t.transaction_ref_table <> 'PER_APPRAISALS'
2010: ) a, -- bug 3635925 , bug 5357274, bug 5990955
2011: wf_item_attribute_values s
2012: where a.item_type = itemtype
2013: and a.item_type = s.item_type

Line 2021: -- PER_APPRAISALS) as "COMPLETED" or "DELETED", irrespective of status in

2017:
2018: -- start bug 5990955
2019:
2020: --Only the appraisals with a System status (appraisal_system_status in
2021: -- PER_APPRAISALS) as "COMPLETED" or "DELETED", irrespective of status in
2022: -- HR_API_TRANSACTIONS table will be deleted. So looking for the
2023: -- APPRAISAL_SYSTEM_STATUS in the cursor
2024:
2025: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is

Line 2027: FROM hr_api_transactions t, per_appraisals a

2023: -- APPRAISAL_SYSTEM_STATUS in the cursor
2024:
2025: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2026: SELECT t.item_type, t.item_key, t.transaction_id
2027: FROM hr_api_transactions t, per_appraisals a
2028: WHERE t.transaction_ref_table = 'PER_APPRAISALS'
2029: AND t.last_update_date <= sysdate - c_transaction_age
2030: AND t.transaction_ref_id = a.appraisal_id
2031: AND a.appraisal_system_status IN ('DELETED','COMPLETED');

Line 2028: WHERE t.transaction_ref_table = 'PER_APPRAISALS'

2024:
2025: CURSOR csr_wfdfctitmsapprs (c_transaction_age in number) is
2026: SELECT t.item_type, t.item_key, t.transaction_id
2027: FROM hr_api_transactions t, per_appraisals a
2028: WHERE t.transaction_ref_table = 'PER_APPRAISALS'
2029: AND t.last_update_date <= sysdate - c_transaction_age
2030: AND t.transaction_ref_id = a.appraisal_id
2031: AND a.appraisal_system_status IN ('DELETED','COMPLETED');
2032: