DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on FND_APPLICATION

Line 3141: fnd_application fa

3137: )
3138: IS
3139: select htr.appl_dynamic_template_process
3140: from hxc_time_recipients htr,
3141: fnd_application fa
3142: where fa.application_short_name = p_dyn_template_app
3143: and htr.application_id = fa.application_id;
3144:
3145: CURSOR c_last_timecard(

Line 4405: l_app_recipient fnd_application_tl.application_name%TYPE;

4401: l_parent_ovn hxc_time_building_blocks.object_version_number%TYPE;
4402: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
4403: l_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE;
4404: l_app_status VARCHAR2(500);
4405: l_app_recipient fnd_application_tl.application_name%TYPE;
4406: l_approver_id per_all_people_f.person_id%TYPE;
4407: l_attribute_index NUMBER;
4408: l_dummy varchar2(1);
4409: l_time_category_id number;

Line 4619: ,fnd_application_tl favtl

4615: ,favtl.application_name
4616: ,apsum.approver_id
4617: ,apsum.time_category_id
4618: FROM hxc_app_period_summary apsum
4619: ,fnd_application_tl favtl
4620: ,hxc_time_recipients htr
4621: WHERE apsum.application_period_id = p_app_period_id
4622: AND favtl.application_id = htr.application_id
4623: AND htr.time_recipient_id = apsum.time_recipient_id

Line 5641: fnd_application fa

5637: )
5638: IS
5639: select htr.appl_dynamic_template_process
5640: from hxc_time_recipients htr,
5641: fnd_application fa
5642: where fa.application_short_name = p_dyn_template_app
5643: and htr.application_id = fa.application_id;
5644:
5645: CURSOR c_otm_retrieval_process(