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 2160: ,p_base_table_name => 'pay_run_types_f'

2156: -- Call the corresponding datetrack api
2157: --
2158: dt_api.find_dt_upd_modes
2159: (p_effective_date => p_effective_date
2160: ,p_base_table_name => 'pay_run_types_f'
2161: ,p_base_key_column => 'run_type_id'
2162: ,p_base_key_value => p_base_key_value
2163: ,p_correction => p_correction
2164: ,p_update => p_update

Line 2213: ,p_base_table_name => 'pay_run_types_f'

2209: -- Call the corresponding datetrack api
2210: --
2211: dt_api.find_dt_del_modes
2212: (p_effective_date => p_effective_date
2213: ,p_base_table_name => 'pay_run_types_f'
2214: ,p_base_key_column => 'run_type_id'
2215: ,p_base_key_value => p_base_key_value
2216: ,p_zap => p_zap
2217: ,p_delete => p_delete

Line 2248: (p_base_table_name => 'pay_run_types_f'

2244: -- version number.
2245: --
2246: l_object_version_number :=
2247: dt_api.get_object_version_number
2248: (p_base_table_name => 'pay_run_types_f'
2249: ,p_base_key_column => 'run_type_id'
2250: ,p_base_key_value => p_base_key_value
2251: );
2252: --

Line 2258: update pay_run_types_f t

2254: --
2255: -- Update the specified datetrack row setting the effective
2256: -- end date to the specified new effective end date.
2257: --
2258: update pay_run_types_f t
2259: set t.effective_end_date = p_new_effective_end_date
2260: , t.object_version_number = l_object_version_number
2261: where t.run_type_id = p_base_key_value
2262: and p_effective_date

Line 2333: from pay_run_types_f

2329: ,run_information28
2330: ,run_information29
2331: ,run_information30
2332: ,object_version_number
2333: from pay_run_types_f
2334: where run_type_id = p_run_type_id
2335: and p_effective_date
2336: between effective_start_date and effective_end_date
2337: for update nowait;

Line 2396: ,p_base_table_name => 'pay_run_types_f'

2392: --
2393: dt_api.validate_dt_mode
2394: (p_effective_date => p_effective_date
2395: ,p_datetrack_mode => p_datetrack_mode
2396: ,p_base_table_name => 'pay_run_types_f'
2397: ,p_base_key_column => 'run_type_id'
2398: ,p_base_key_value => p_run_type_id
2399: ,p_child_table_name1 => 'pay_element_type_usages_f'
2400: ,p_child_key_column1 => 'element_type_usage_id'

Line 2415: ,p_base_table_name => 'pay_run_types_f'

2411: --
2412: validate_dt_mode
2413: (p_effective_date => p_effective_date
2414: ,p_datetrack_mode => p_datetrack_mode
2415: ,p_base_table_name => 'pay_run_types_f'
2416: ,p_base_key_column => 'run_type_id'
2417: ,p_base_key_value => p_run_type_id
2418: ,p_child_table_name1 => 'pay_run_type_usages_f'
2419: ,p_child_key_column1 => 'run_type_usage_id'

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

2452: -- The object is locked therefore we need to supply a meaningful
2453: -- error message.
2454: --
2455: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
2456: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');
2457: fnd_message.raise_error;
2458: End lck;
2459: --
2460: -- ----------------------------------------------------------------------------