APPS.PAY_AC_ACTION_ARCH dependencies on HR_GENERAL

Line 1814: hr_general.decode_lookup

1810: cp_run_assignment_action_id in number ) IS
1811:
1812: select fnd_date.date_to_canonical(ptp.start_date),
1813: fnd_date.date_to_canonical(ptp.end_date),
1814: hr_general.decode_lookup
1815: (DECODE (UPPER (ec.classification_name),
1816: 'EARNINGS', 'US_EARNINGS',
1817: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
1818: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

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

1886: FROM per_addresses pa
1887: ,pay_us_states pus
1888: WHERE pa.person_id = cp_person_id
1889: AND pa.primary_flag = 'Y'
1890: AND p_curr_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
1891: AND pa.business_group_id = cp_bg_id
1892: AND pa.region_2 = pus.state_abbrev
1893: AND pa.style = p_legislation_code;
1894:

Line 4262: hr_general.decode_lookup

4258:
4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4260: fnd_date.date_to_canonical(ptp.start_date),
4261: fnd_date.date_to_canonical(ptp.end_date),
4262: hr_general.decode_lookup
4263: (DECODE (UPPER (ec.classification_name),
4264: 'EARNINGS', 'US_EARNINGS',
4265: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
4266: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

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

4355: FROM per_addresses pa
4356: ,pay_us_states pus
4357: WHERE pa.person_id = cp_person_id
4358: AND pa.primary_flag = 'Y'
4359: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
4360: AND pa.business_group_id = cp_bg_id
4361: AND pa.region_2 = pus.state_abbrev
4362: AND pa.style = p_legislation_code;
4363:

Line 4757: hr_general.decode_lookup

4753: cp_run_assignment_action_id in number ) IS
4754:
4755: select fnd_date.date_to_canonical(ptp.start_date),
4756: fnd_date.date_to_canonical(ptp.end_date),
4757: hr_general.decode_lookup
4758: (DECODE (UPPER (ec.classification_name),
4759: 'EARNINGS', 'US_EARNINGS',
4760: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',
4761: 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS',

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

4857: FROM per_addresses pa
4858: ,pay_us_states pus
4859: WHERE pa.person_id = cp_person_id
4860: AND pa.primary_flag = 'Y'
4861: AND p_pymt_eff_date between pa.date_from AND NVL(pa.date_to, hr_general.END_OF_TIME)
4862: AND pa.business_group_id = cp_bg_id
4863: AND pa.region_2 = pus.state_abbrev
4864: AND pa.style = p_legislation_code;
4865: