eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_USER_INIT_DEDN dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 200: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

196: l_total_owed_create VARCHAR2(1);
197: l_threshold_amt_create VARCHAR2(1);
198:
199: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
200: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
201: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
202: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
203: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
204: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 202: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

198:
199: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
200: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
201: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
202: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
203: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
204: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
205: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
206: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.

Line 204: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

200: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
201: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
202: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
203: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
204: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
205: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
206: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
207:
208: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types

Line 404: from pay_shadow_element_types

400: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',7);
401: --
402: select element_type_id, object_version_number
403: into l_element_type_id, l_ele_obj_ver_number
404: from pay_shadow_element_types
405: where template_id = l_template_id
406: and element_name = p_ele_name;
407: --
408: select element_type_id, object_version_number

Line 410: from pay_shadow_element_types

406: and element_name = p_ele_name;
407: --
408: select element_type_id, object_version_number
409: into l_sf_element_type_id, l_sf_ele_obj_ver_number
410: from pay_shadow_element_types
411: where template_id = l_template_id
412: and element_name = p_ele_name||' Special Features';
413: --
414: if p_ele_processing_type = 'R' then

Line 417: from pay_shadow_element_types

413: --
414: if p_ele_processing_type = 'R' then
415: select element_type_id, object_version_number
416: into l_si_element_type_id, l_si_ele_obj_ver_number
417: from pay_shadow_element_types
418: where template_id = l_template_id
419: and element_name = p_ele_name||' Special Inputs';
420: end if;
421: --

Line 715: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

711: l_object_version_number NUMBER(9); -- Object Version Number
712:
713: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
714:
715: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
716: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
717: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
718: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 717: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

713: l_bg_name VARCHAR2(60); -- Get from bg short name passed in.
714:
715: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
716: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
717: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
718: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
720: l_sf2_ele_obj_ver_number NUMBER(9); -- Object Version Number
721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

715: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
716: l_ele_obj_ver_number NUMBER(9); -- Object Version Number
717: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
718: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
720: l_sf2_ele_obj_ver_number NUMBER(9); -- Object Version Number
721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
722: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
723: l_ver_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

717: l_sf_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
718: l_sf_ele_obj_ver_number NUMBER(9); -- Object Version Number
719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
720: l_sf2_ele_obj_ver_number NUMBER(9); -- Object Version Number
721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
722: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
723: l_ver_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
724: l_ver_ele_obj_ver_number NUMBER(9); -- Object Version Number
725: l_fee_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

Line 723: l_ver_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

719: l_sf2_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
720: l_sf2_ele_obj_ver_number NUMBER(9); -- Object Version Number
721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
722: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
723: l_ver_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
724: l_ver_ele_obj_ver_number NUMBER(9); -- Object Version Number
725: l_fee_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
726: l_fee_ele_obj_ver_number NUMBER(9); -- Object Version Number
727: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.

Line 725: l_fee_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

721: l_si_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
722: l_si_ele_obj_ver_number NUMBER(9); -- Object Version Number
723: l_ver_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
724: l_ver_ele_obj_ver_number NUMBER(9); -- Object Version Number
725: l_fee_element_type_id NUMBER(9); -- Get from pay_shadow_element_types
726: l_fee_ele_obj_ver_number NUMBER(9); -- Object Version Number
727: l_base_element_type_id NUMBER(9); -- Populated by insertion of element type.
728:
729: l_pri_bal_id NUMBER(9); -- Get from pay_balance_types

Line 879: from pay_shadow_element_types

875: ,p_object_version_number => l_object_version_number);
876: --
877: select element_type_id, object_version_number
878: into l_element_type_id, l_ele_obj_ver_number
879: from pay_shadow_element_types
880: where template_id = l_template_id
881: and element_name = p_ele_name;
882: --
883: select element_type_id, object_version_number

Line 885: from pay_shadow_element_types

881: and element_name = p_ele_name;
882: --
883: select element_type_id, object_version_number
884: into l_sf_element_type_id, l_sf_ele_obj_ver_number
885: from pay_shadow_element_types
886: where template_id = l_template_id
887: and element_name = p_ele_name||' Special Features';
888: --
889: select element_type_id, object_version_number

Line 891: from pay_shadow_element_types

887: and element_name = p_ele_name||' Special Features';
888: --
889: select element_type_id, object_version_number
890: into l_sf2_element_type_id, l_sf2_ele_obj_ver_number
891: from pay_shadow_element_types
892: where template_id = l_template_id
893: and element_name = p_ele_name||' Special Features 2';
894: --
895: select element_type_id, object_version_number

Line 897: from pay_shadow_element_types

893: and element_name = p_ele_name||' Special Features 2';
894: --
895: select element_type_id, object_version_number
896: into l_fee_element_type_id, l_fee_ele_obj_ver_number
897: from pay_shadow_element_types
898: where template_id = l_template_id
899: and element_name = p_ele_name||' Fees';
900: --
901: select element_type_id, object_version_number

Line 903: from pay_shadow_element_types

899: and element_name = p_ele_name||' Fees';
900: --
901: select element_type_id, object_version_number
902: into l_ver_element_type_id, l_ver_ele_obj_ver_number
903: from pay_shadow_element_types
904: where template_id = l_template_id
905: and element_name = p_ele_name||' Verifier';
906: --
907: select element_type_id, object_version_number

Line 909: from pay_shadow_element_types

905: and element_name = p_ele_name||' Verifier';
906: --
907: select element_type_id, object_version_number
908: into l_si_element_type_id, l_si_ele_obj_ver_number
909: from pay_shadow_element_types
910: where template_id = l_template_id
911: and element_name = p_ele_name||' Special Inputs';
912: --
913: ---------------------------- Update Shadow Structure ----------------------