DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on FND_APPLICATION

Line 2841: fnd_application fa

2837: )
2838: IS
2839: select htr.appl_dynamic_template_process
2840: from hxc_time_recipients htr,
2841: fnd_application fa
2842: where fa.application_short_name = p_dyn_template_app
2843: and htr.application_id = fa.application_id;
2844:
2845: CURSOR c_last_timecard(

Line 4069: l_app_recipient fnd_application_tl.application_name%TYPE;

4065: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;
4066: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
4067: l_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE;
4068: l_app_status VARCHAR2(500);
4069: l_app_recipient fnd_application_tl.application_name%TYPE;
4070: l_approver_id per_all_people_f.person_id%TYPE;
4071: l_attribute_index NUMBER;
4072: l_dummy varchar2(1);
4073: l_time_category_id number;

Line 4283: ,fnd_application_tl favtl

4279: ,favtl.application_name
4280: ,apsum.approver_id
4281: ,apsum.time_category_id
4282: FROM hxc_app_period_summary apsum
4283: ,fnd_application_tl favtl
4284: ,hxc_time_recipients htr
4285: WHERE apsum.application_period_id = p_app_period_id
4286: AND favtl.application_id = htr.application_id
4287: AND htr.time_recipient_id = apsum.time_recipient_id

Line 5222: fnd_application fa

5218: )
5219: IS
5220: select htr.appl_dynamic_template_process
5221: from hxc_time_recipients htr,
5222: fnd_application fa
5223: where fa.application_short_name = p_dyn_template_app
5224: and htr.application_id = fa.application_id;
5225:
5226: CURSOR c_otm_retrieval_process(