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 203: l_element_type_id NUMBER(9); -- Get from pay_shadow_element_types

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

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

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

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

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

Line 407: from pay_shadow_element_types

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

Line 413: from pay_shadow_element_types

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

Line 420: from pay_shadow_element_types

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 882: from pay_shadow_element_types

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

Line 888: from pay_shadow_element_types

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

Line 894: from pay_shadow_element_types

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

Line 900: from pay_shadow_element_types

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

Line 906: from pay_shadow_element_types

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

Line 912: from pay_shadow_element_types

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