DBA Data[Home] [Help]

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on HR_GENERAL

Line 2239: AND NVL(pa.date_to, hr_general.END_OF_TIME)

2235: ,pay_us_states pus
2236: WHERE pa.person_id = cp_person_id
2237: AND pa.primary_flag = 'Y'
2238: AND cp_effective_date BETWEEN pa.date_from
2239: AND NVL(pa.date_to, hr_general.END_OF_TIME)
2240: AND pa.business_group_id = cp_business_group_id
2241: AND pa.region_2 = pus.state_abbrev
2242: AND pa.style = cp_legislation_code;
2243:

Line 4129: HR_GENERAL2.mask_characters(csr_get_sim_arch_info_rec.action_information7);');

4125: ,csr_get_sim_arch_info_rec.action_information15);');
4126:
4127: build_sql(sqlstr,l_cntr_sql,
4128: 'csr_get_sim_arch_info_rec.action_information7 :=
4129: HR_GENERAL2.mask_characters(csr_get_sim_arch_info_rec.action_information7);');
4130:
4131: END IF;
4132:
4133: build_sql(sqlstr,l_cntr_sql,