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.GHR_CORR_CANC_SF52 dependencies on PAY_ELEMENT_TYPES_F

Line 1656: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt

1652: l_bus_group_id NUMBER;
1653:
1654: CURSOR c_element_name(p_element_link_id NUMBER) IS
1655: SELECT elt.element_name
1656: FROM PAY_ELEMENT_LINKS_F ell,PAY_ELEMENT_TYPES_F elt
1657: WHERE ell.ELEMENT_type_id = elt.element_type_id
1658: AND ell.element_link_id = p_element_link_id;
1659: --
1660: -- Created the following cursor to handle same day other pay actions.

Line 1664: PAY_ELEMENT_TYPES_F elt,

1660: -- Created the following cursor to handle same day other pay actions.
1661: CURSOR c_element_name1(p_element_entry_id NUMBER) IS
1662: SELECT elt.element_name
1663: FROM PAY_ELEMENT_LINKS_F ell,
1664: PAY_ELEMENT_TYPES_F elt,
1665: pay_element_entries_f ele
1666: WHERE ell.ELEMENT_type_id = elt.element_type_id
1667: AND ele.element_type_id = elt.element_type_id
1668: AND ell.element_link_id = ele.element_link_id

Line 3805: FROM PAY_ELEMENT_TYPES_F ELT,

3801: ,cp_eff_date in date
3802: ,p_bg_id IN number)
3803: IS
3804: SELECT ELT.ELEMENT_NAME
3805: FROM PAY_ELEMENT_TYPES_F ELT,
3806: PAY_ELEMENT_LINKS_F ELL,
3807: PAY_ELEMENT_ENTRIES_F ELE
3808: WHERE TRUNC(cp_eff_date) BETWEEN ELT.EFFECTIVE_START_DATE
3809: AND ELT.EFFECTIVE_END_DATE

Line 3835: l_element_name pay_element_types_f.element_name%type;

3831: AND TABLE_NAME = cp_table_name
3832: ORDER BY PROCESS_DATE DESC; -- Line Added by ENUNEZ (04/11/2000) bug# 1235958
3833:
3834: l_ipv_name pay_input_values_f.name%type;
3835: l_element_name pay_element_types_f.element_name%type;
3836: l_proc_warn boolean;
3837: l_proc varchar2(30):='update_eleentval';
3838: l_eff_date date;
3839: l_asg_id number;

Line 3847: from pay_element_types_f elt,

3843: ,input_name in varchar2
3844: ,eff_date in date
3845: ,p_bg_id in number) is
3846: select ipv.uom
3847: from pay_element_types_f elt,
3848: pay_input_values_f ipv
3849: where trunc(eff_date) between elt.effective_start_date
3850: and elt.effective_end_date
3851: and trunc(eff_date) between ipv.effective_start_date

Line 5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee

5581: pet.effective_start_date,
5582: pet.effective_end_date,
5583: pet.processing_type
5584: from
5585: pay_element_types_f pet, pay_element_links_f pel, pay_element_entries_f pee
5586: where pee.element_entry_id = cp_element_entry_id and
5587: pee.element_link_id = pel.element_link_id and
5588: pet.element_type_id = pel.element_type_id and
5589: cp_effective_start_date between pee.effective_start_date and pee.effective_end_date and

Line 6647: FROM pay_element_types_f elt

6643: CURSOR C_element_exists(p_element_name IN VARCHAR2,
6644: p_assignment_id IN number,
6645: p_effective_date IN DATE) IS
6646: SELECT '1'
6647: FROM pay_element_types_f elt
6648: ,pay_element_entries_f ele
6649: WHERE elt.element_type_id = ele.element_type_id
6650: AND elt.element_name= p_element_name
6651: AND ele.assignment_id = p_assignment_id