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_SE_HOLIDAY_PAY dependencies on FF_DATABASE_ITEMS

Line 137: csr_v_balance_name ff_database_items.user_name%TYPE

133: AND eev1.effective_start_date >= l_earning_start_date
134: AND eev1.effective_end_date <= l_earning_end_date;
135:
136: CURSOR csr_get_defined_balance_id (
137: csr_v_balance_name ff_database_items.user_name%TYPE
138: )
139: IS
140: SELECT ue.creator_id
141: FROM ff_user_entities ue

Line 142: ,ff_database_items di

138: )
139: IS
140: SELECT ue.creator_id
141: FROM ff_user_entities ue
142: ,ff_database_items di
143: WHERE di.user_name = csr_v_balance_name
144: AND ue.user_entity_id = di.user_entity_id
145: AND ue.legislation_code = 'SE'
146: AND ue.business_group_id IS NULL

Line 564: csr_v_balance_name ff_database_items.user_name%TYPE

560: AND et.element_name NOT IN
561: ('Advance Holiday Details', 'Advance Holiday Pay');
562:
563: CURSOR csr_get_defined_balance_id (
564: csr_v_balance_name ff_database_items.user_name%TYPE
565: )
566: IS
567: SELECT ue.creator_id
568: FROM ff_user_entities ue

Line 569: ,ff_database_items di

565: )
566: IS
567: SELECT ue.creator_id
568: FROM ff_user_entities ue
569: ,ff_database_items di
570: WHERE di.user_name = csr_v_balance_name
571: AND ue.user_entity_id = di.user_entity_id
572: AND ue.legislation_code = 'SE'
573: AND ue.business_group_id IS NULL

Line 828: csr_v_balance_name ff_database_items.user_name%TYPE

824: --AND peevf2.effective_end_date <= to_date('31-jan-2000')
825: ;
826:
827: CURSOR csr_get_defined_balance_id (
828: csr_v_balance_name ff_database_items.user_name%TYPE
829: )
830: IS
831: SELECT ue.creator_id
832: FROM ff_user_entities ue

Line 833: ,ff_database_items di

829: )
830: IS
831: SELECT ue.creator_id
832: FROM ff_user_entities ue
833: ,ff_database_items di
834: WHERE di.user_name = csr_v_balance_name
835: AND ue.user_entity_id = di.user_entity_id
836: AND ue.legislation_code = 'SE'
837: AND ue.business_group_id IS NULL

Line 1351: csr_v_balance_name ff_database_items.user_name%TYPE

1347: AND hoi2.org_information_context = 'SE_HOLIDAY_YEAR_DEFN'
1348: AND hoi2.org_information1 IS NOT NULL;
1349:
1350: CURSOR csr_get_defined_balance_id (
1351: csr_v_balance_name ff_database_items.user_name%TYPE
1352: )
1353: IS
1354: SELECT ue.creator_id
1355: FROM ff_user_entities ue

Line 1356: ,ff_database_items di

1352: )
1353: IS
1354: SELECT ue.creator_id
1355: FROM ff_user_entities ue
1356: ,ff_database_items di
1357: WHERE di.user_name = csr_v_balance_name
1358: AND ue.user_entity_id = di.user_entity_id
1359: AND ue.legislation_code = 'SE'
1360: AND ue.business_group_id IS NULL

Line 1787: csr_v_balance_name ff_database_items.user_name%TYPE

1783: AND hoi2.org_information_context = 'SE_HOLIDAY_YEAR_DEFN'
1784: AND hoi2.org_information1 IS NOT NULL;
1785:
1786: CURSOR csr_get_defined_balance_id (
1787: csr_v_balance_name ff_database_items.user_name%TYPE
1788: )
1789: IS
1790: SELECT ue.creator_id
1791: FROM ff_user_entities ue

Line 1792: ,ff_database_items di

1788: )
1789: IS
1790: SELECT ue.creator_id
1791: FROM ff_user_entities ue
1792: ,ff_database_items di
1793: WHERE di.user_name = csr_v_balance_name
1794: AND ue.user_entity_id = di.user_entity_id
1795: AND ue.legislation_code = 'SE'
1796: AND ue.business_group_id IS NULL

Line 2071: csr_v_balance_name ff_database_items.user_name%TYPE

2067: AND hoi2.org_information_context = 'SE_HOLIDAY_YEAR_DEFN'
2068: AND hoi2.org_information1 IS NOT NULL;
2069:
2070: CURSOR csr_get_defined_balance_id (
2071: csr_v_balance_name ff_database_items.user_name%TYPE
2072: )
2073: IS
2074: SELECT ue.creator_id
2075: FROM ff_user_entities ue

Line 2076: ,ff_database_items di

2072: )
2073: IS
2074: SELECT ue.creator_id
2075: FROM ff_user_entities ue
2076: ,ff_database_items di
2077: WHERE di.user_name = csr_v_balance_name
2078: AND ue.user_entity_id = di.user_entity_id
2079: AND ue.legislation_code = 'SE'
2080: AND ue.business_group_id IS NULL

Line 2578: csr_v_balance_name ff_database_items.user_name%TYPE

2574: AND et.element_name NOT IN
2575: ('Advance Holiday Details', 'Advance Holiday Pay');
2576:
2577: CURSOR csr_get_defined_balance_id (
2578: csr_v_balance_name ff_database_items.user_name%TYPE
2579: )
2580: IS
2581: SELECT ue.creator_id
2582: FROM ff_user_entities ue

Line 2583: ,ff_database_items di

2579: )
2580: IS
2581: SELECT ue.creator_id
2582: FROM ff_user_entities ue
2583: ,ff_database_items di
2584: WHERE di.user_name = csr_v_balance_name
2585: AND ue.user_entity_id = di.user_entity_id
2586: AND ue.legislation_code = 'SE'
2587: AND ue.business_group_id IS NULL