APPS.PAY_AC_ACTION_ARCH dependencies on HR_GENERAL

Line 2154: hr_general.decode_lookup

2150: cp_run_assignment_action_id in number ) IS
2151:
2152: select fnd_date.date_to_canonical(ptp.start_date),
2153: fnd_date.date_to_canonical(ptp.end_date),
2154: hr_general.decode_lookup
2155: (DECODE (UPPER (ec.classification_name),
2156: 'EARNINGS', 'US_EARNINGS',
2157: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
2158: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

Line 2247: AND p_curr_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

2243: FROM per_addresses pa
2244: ,pay_us_states pus
2245: WHERE pa.person_id = cp_person_id
2246: AND pa.primary_flag = 'Y'
2247: AND p_curr_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
2248: AND pa.business_group_id = cp_bg_id
2249: AND pa.region_2 = pus.state_abbrev
2250: AND pa.style = p_legislation_code;
2251:

Line 4756: hr_general.decode_lookup

4752:
4753: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4754: fnd_date.date_to_canonical(ptp.start_date),
4755: fnd_date.date_to_canonical(ptp.end_date),
4756: hr_general.decode_lookup
4757: (DECODE (UPPER (ec.classification_name),
4758: 'EARNINGS', 'US_EARNINGS',
4759: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
4760: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

Line 4910: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

4906: FROM per_addresses pa
4907: ,pay_us_states pus
4908: WHERE pa.person_id = cp_person_id
4909: AND pa.primary_flag = 'Y'
4910: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
4911: AND pa.business_group_id = cp_bg_id
4912: AND pa.region_2 = pus.state_abbrev
4913: AND pa.style = p_legislation_code;
4914:

Line 5367: hr_general.decode_lookup

5363: cp_run_assignment_action_id in number ) IS
5364:
5365: select fnd_date.date_to_canonical(ptp.start_date),
5366: fnd_date.date_to_canonical(ptp.end_date),
5367: hr_general.decode_lookup
5368: (DECODE (UPPER (ec.classification_name),
5369: 'EARNINGS', 'US_EARNINGS',
5370: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
5371: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

Line 5482: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

5478: FROM per_addresses pa
5479: ,pay_us_states pus
5480: WHERE pa.person_id = cp_person_id
5481: AND pa.primary_flag = 'Y'
5482: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
5483: AND pa.business_group_id = cp_bg_id
5484: AND pa.region_2 = pus.state_abbrev
5485: AND pa.style = p_legislation_code;
5486:

Line 5967: hr_general.decode_lookup

5963: cp_run_assignment_action_id in number ) IS
5964:
5965: select fnd_date.date_to_canonical(ptp.start_date),
5966: fnd_date.date_to_canonical(ptp.end_date),
5967: hr_general.decode_lookup
5968: (DECODE (UPPER (ec.classification_name),
5969: 'EARNINGS', 'US_EARNINGS',
5970: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
5971: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

Line 6083: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)

6079: FROM per_addresses pa
6080: ,pay_us_states pus
6081: WHERE pa.person_id = cp_person_id
6082: AND pa.primary_flag = 'Y'
6083: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
6084: AND pa.business_group_id = cp_bg_id
6085: AND pa.region_2 = pus.state_abbrev
6086: AND pa.style = p_legislation_code;
6087: