APPS.PAY_PRT_SHD dependencies on PAY_RUN_TYPES_F

Line 95: from pay_run_types_f

91: ,run_information28
92: ,run_information29
93: ,run_information30
94: ,object_version_number
95: from pay_run_types_f
96: where run_type_id = p_run_type_id
97: and p_effective_date
98: between effective_start_date and effective_end_date;
99: --

Line 2183: ,p_base_table_name => 'pay_run_types_f'

2179: -- Call the corresponding datetrack api
2180: --
2181: dt_api.find_dt_upd_modes
2182: (p_effective_date => p_effective_date
2183: ,p_base_table_name => 'pay_run_types_f'
2184: ,p_base_key_column => 'run_type_id'
2185: ,p_base_key_value => p_base_key_value
2186: ,p_correction => p_correction
2187: ,p_update => p_update

Line 2236: ,p_base_table_name => 'pay_run_types_f'

2232: -- Call the corresponding datetrack api
2233: --
2234: dt_api.find_dt_del_modes
2235: (p_effective_date => p_effective_date
2236: ,p_base_table_name => 'pay_run_types_f'
2237: ,p_base_key_column => 'run_type_id'
2238: ,p_base_key_value => p_base_key_value
2239: ,p_zap => p_zap
2240: ,p_delete => p_delete

Line 2271: (p_base_table_name => 'pay_run_types_f'

2267: -- version number.
2268: --
2269: l_object_version_number :=
2270: dt_api.get_object_version_number
2271: (p_base_table_name => 'pay_run_types_f'
2272: ,p_base_key_column => 'run_type_id'
2273: ,p_base_key_value => p_base_key_value
2274: );
2275: --

Line 2281: update pay_run_types_f t

2277: --
2278: -- Update the specified datetrack row setting the effective
2279: -- end date to the specified new effective end date.
2280: --
2281: update pay_run_types_f t
2282: set t.effective_end_date = p_new_effective_end_date
2283: , t.object_version_number = l_object_version_number
2284: where t.run_type_id = p_base_key_value
2285: and p_effective_date

Line 2356: from pay_run_types_f

2352: ,run_information28
2353: ,run_information29
2354: ,run_information30
2355: ,object_version_number
2356: from pay_run_types_f
2357: where run_type_id = p_run_type_id
2358: and p_effective_date
2359: between effective_start_date and effective_end_date
2360: for update nowait;

Line 2419: ,p_base_table_name => 'pay_run_types_f'

2415: --
2416: dt_api.validate_dt_mode
2417: (p_effective_date => p_effective_date
2418: ,p_datetrack_mode => p_datetrack_mode
2419: ,p_base_table_name => 'pay_run_types_f'
2420: ,p_base_key_column => 'run_type_id'
2421: ,p_base_key_value => p_run_type_id
2422: ,p_child_table_name1 => 'pay_element_type_usages_f'
2423: ,p_child_key_column1 => 'element_type_usage_id'

Line 2438: ,p_base_table_name => 'pay_run_types_f'

2434: --
2435: validate_dt_mode
2436: (p_effective_date => p_effective_date
2437: ,p_datetrack_mode => p_datetrack_mode
2438: ,p_base_table_name => 'pay_run_types_f'
2439: ,p_base_key_column => 'run_type_id'
2440: ,p_base_key_value => p_run_type_id
2441: ,p_child_table_name1 => 'pay_run_type_usages_f'
2442: ,p_child_key_column1 => 'run_type_usage_id'

Line 2479: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');

2475: -- The object is locked therefore we need to supply a meaningful
2476: -- error message.
2477: --
2478: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
2479: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');
2480: fnd_message.raise_error;
2481: End lck;
2482: --
2483: -- ----------------------------------------------------------------------------