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.HRSTRDBI dependencies on FF_FORMULAS_F

Line 182: ff_formulas_f.

178: Route ACCRUAL_PLAN_SERVICE_DATES and its dbitems.
179: Route ACCRUAL_PLAN_DATES and its dbitems.
180: Added TEMPLATE_BIS_DAYS_TO_HOURS, TEMPLATE_FTE,
181: TEMPLATE_HEAD, EXAMPLE_BIS_OT_BAND1 to
182: ff_formulas_f.
183: Created insert_formula to insert PTO_PAYROLL_CARRYOVER,
184: PTO_PAYROLL_PERIOD_ACCRUAL, PTO_PAYROLL_CALCULATION,
185: PTO_ROLLING_CARRYOVER, PTO_ROLLING_PERIOD_ACCRUAL,
186: PTO_ROLLING_ACCRUAL, PTO_SIMPLE_CARRYOVER,

Line 188: into ff_formulas_f.

184: PTO_PAYROLL_PERIOD_ACCRUAL, PTO_PAYROLL_CALCULATION,
185: PTO_ROLLING_CARRYOVER, PTO_ROLLING_PERIOD_ACCRUAL,
186: PTO_ROLLING_ACCRUAL, PTO_SIMPLE_CARRYOVER,
187: PTO_SIMPLE_PERIOD_ACCRUAL, PTO_SIMPLE_MULTIPLIER
188: into ff_formulas_f.
189: Created insert_functions to insert GET_HOURS_WORKED,
190: CURRENCY_CONVERT_AMOUNT, GET_RATE_TYPE,
191: CHECK_RATE_TYPE and accrual functions
192: into ff_functions.

Line 6403: INSERT INTO ff_formulas_f

6399: into l_ftype_id
6400: from ff_formula_types
6401: where formula_type_name = 'QuickPaint';
6402: --
6403: INSERT INTO ff_formulas_f
6404: (formula_id,
6405: effective_start_date,
6406: effective_end_date,
6407: business_group_id,

Line 6583: INSERT INTO ff_formulas_f

6579: into l_ftype_id
6580: from ff_formula_types
6581: where formula_type_name = 'QuickPaint';
6582: --
6583: INSERT INTO ff_formulas_f
6584: (formula_id,
6585: effective_start_date,
6586: effective_end_date,
6587: business_group_id,

Line 6657: INSERT INTO ff_formulas_f

6653: into l_ftype_id
6654: from ff_formula_types
6655: where formula_type_name = 'QuickPaint';
6656: --
6657: INSERT INTO ff_formulas_f
6658: (formula_id,
6659: effective_start_date,
6660: effective_end_date,
6661: business_group_id,

Line 6731: INSERT INTO ff_formulas_f

6727: into l_ftype_id
6728: from ff_formula_types
6729: where formula_type_name = 'QuickPaint';
6730: --
6731: INSERT INTO ff_formulas_f
6732: (formula_id,
6733: effective_start_date,
6734: effective_end_date,
6735: business_group_id,

Line 6869: INSERT INTO ff_formulas_f

6865: into l_ftype_id
6866: from ff_formula_types
6867: where formula_type_name = 'Accrual Carryover';
6868: --
6869: INSERT INTO ff_formulas_f
6870: (formula_id,
6871: effective_start_date,
6872: effective_end_date,
6873: business_group_id,

Line 7034: INSERT INTO ff_formulas_f

7030: into l_ftype_id
7031: from ff_formula_types
7032: where formula_type_name = 'Accrual Subformula';
7033: --
7034: INSERT INTO ff_formulas_f
7035: (formula_id,
7036: effective_start_date,
7037: effective_end_date,
7038: business_group_id,

Line 7409: INSERT INTO ff_formulas_f

7405: into l_ftype_id
7406: from ff_formula_types
7407: where formula_type_name = 'Accrual';
7408: --
7409: INSERT INTO ff_formulas_f
7410: (formula_id,
7411: effective_start_date,
7412: effective_end_date,
7413: business_group_id,

Line 7457: INSERT INTO ff_formulas_f

7453: into l_ftype_id
7454: from ff_formula_types
7455: where formula_type_name = 'Accrual Carryover';
7456: --
7457: INSERT INTO ff_formulas_f
7458: (formula_id,
7459: effective_start_date,
7460: effective_end_date,
7461: business_group_id,

Line 7581: INSERT INTO ff_formulas_f

7577: into l_ftype_id
7578: from ff_formula_types
7579: where formula_type_name = 'Accrual Subformula';
7580: --
7581: INSERT INTO ff_formulas_f
7582: (formula_id,
7583: effective_start_date,
7584: effective_end_date,
7585: business_group_id,

Line 7920: INSERT INTO ff_formulas_f

7916: into l_ftype_id
7917: from ff_formula_types
7918: where formula_type_name = 'Accrual';
7919: --
7920: INSERT INTO ff_formulas_f
7921: (formula_id,
7922: effective_start_date,
7923: effective_end_date,
7924: business_group_id,

Line 7983: INSERT INTO ff_formulas_f

7979: into l_ftype_id
7980: from ff_formula_types
7981: where formula_type_name = 'Accrual Carryover';
7982: --
7983: INSERT INTO ff_formulas_f
7984: (formula_id,
7985: effective_start_date,
7986: effective_end_date,
7987: business_group_id,

Line 8105: INSERT INTO ff_formulas_f

8101: into l_ftype_id
8102: from ff_formula_types
8103: where formula_type_name = 'Accrual Subformula';
8104: --
8105: INSERT INTO ff_formulas_f
8106: (formula_id,
8107: effective_start_date,
8108: effective_end_date,
8109: business_group_id,

Line 8449: INSERT INTO ff_formulas_f

8445: into l_ftype_id
8446: from ff_formula_types
8447: where formula_type_name = 'Accrual';
8448: --
8449: INSERT INTO ff_formulas_f
8450: (formula_id,
8451: effective_start_date,
8452: effective_end_date,
8453: business_group_id,

Line 8612: INSERT INTO ff_formulas_f

8608: into l_ftype_id
8609: from ff_formula_types
8610: where formula_type_name = 'Accrual Ineligibility';
8611: --
8612: INSERT INTO ff_formulas_f
8613: (formula_id,
8614: effective_start_date,
8615: effective_end_date,
8616: business_group_id,

Line 8666: INSERT INTO ff_formulas_f

8662: into l_ftype_id
8663: from ff_formula_types
8664: where formula_type_name = 'User Table Validation';
8665: --
8666: INSERT INTO ff_formulas_f
8667: (formula_id,
8668: effective_start_date,
8669: effective_end_date,
8670: business_group_id,

Line 8762: INSERT INTO ff_formulas_f

8758: into l_ftype_id
8759: from ff_formula_types
8760: where formula_type_name = 'QuickPaint';
8761: --
8762: INSERT INTO ff_formulas_f
8763: (formula_id,
8764: effective_start_date,
8765: effective_end_date,
8766: business_group_id,

Line 8914: INSERT INTO ff_formulas_f

8910: */
8911: )
8912: return duration, invalid_msg';
8913: --
8914: INSERT INTO ff_formulas_f
8915: (formula_id,
8916: effective_start_date,
8917: effective_end_date,
8918: business_group_id,

Line 8965: INSERT INTO ff_formulas_f

8961: into l_ftype_id
8962: from ff_formula_types
8963: where formula_type_name = 'Oracle Payroll';
8964: --
8965: INSERT INTO ff_formulas_f
8966: (formula_id,
8967: effective_start_date,
8968: effective_end_date,
8969: business_group_id,

Line 9106: INSERT INTO ff_formulas_f

9102: into l_ftype_id
9103: from ff_formula_types
9104: where formula_type_name = 'Net to Gross';
9105: --
9106: INSERT INTO ff_formulas_f
9107: (formula_id,
9108: effective_start_date,
9109: effective_end_date,
9110: business_group_id,

Line 9149: INSERT INTO ff_formulas_f

9145: into l_ftype_id
9146: from ff_formula_types
9147: where formula_type_name = 'QuickPaint';
9148: --
9149: INSERT INTO ff_formulas_f
9150: (formula_id,
9151: effective_start_date,
9152: effective_end_date,
9153: business_group_id,

Line 9209: INSERT INTO ff_formulas_f

9205: into l_ftype_id
9206: from ff_formula_types
9207: where formula_type_name = 'Element Skip';
9208: --
9209: INSERT INTO ff_formulas_f
9210: (formula_id,
9211: effective_start_date,
9212: effective_end_date,
9213: business_group_id,

Line 9694: INSERT INTO ff_formulas_f

9690: into l_ftype_id
9691: from ff_formula_types
9692: where formula_type_name = 'Accrual';
9693: --
9694: INSERT INTO ff_formulas_f
9695: (formula_id,
9696: effective_start_date,
9697: effective_end_date,
9698: business_group_id,

Line 10137: INSERT INTO ff_formulas_f

10133: into l_ftype_id
10134: from ff_formula_types
10135: where formula_type_name = 'Accrual';
10136: --
10137: INSERT INTO ff_formulas_f
10138: (formula_id,
10139: effective_start_date,
10140: effective_end_date,
10141: business_group_id,

Line 10568: INSERT INTO ff_formulas_f

10564: into l_ftype_id
10565: from ff_formula_types
10566: where formula_type_name = 'Accrual';
10567: --
10568: INSERT INTO ff_formulas_f
10569: (formula_id,
10570: effective_start_date,
10571: effective_end_date,
10572: business_group_id,

Line 10690: INSERT INTO ff_formulas_f

10686: into l_ftype_id
10687: from ff_formula_types
10688: where formula_type_name = 'Accrual Subformula';
10689: --
10690: INSERT INTO ff_formulas_f
10691: (formula_id,
10692: effective_start_date,
10693: effective_end_date,
10694: business_group_id,

Line 10751: INSERT INTO ff_formulas_f

10747: into l_ftype_id
10748: from ff_formula_types
10749: where formula_type_name = 'Accrual Carryover';
10750: --
10751: INSERT INTO ff_formulas_f
10752: (formula_id,
10753: effective_start_date,
10754: effective_end_date,
10755: business_group_id,

Line 10800: INSERT INTO ff_formulas_f

10796: into l_ftype_id
10797: from ff_formula_types
10798: where formula_type_name = 'Oracle Payroll';
10799: --
10800: INSERT INTO ff_formulas_f
10801: (formula_id,
10802: effective_start_date,
10803: effective_end_date,
10804: business_group_id,

Line 10903: INSERT INTO ff_formulas_f

10899: into l_ftype_id
10900: from ff_formula_types
10901: where formula_type_name = 'CAGR';
10902: --
10903: INSERT INTO ff_formulas_f
10904: (formula_id,
10905: effective_start_date,
10906: effective_end_date,
10907: business_group_id,

Line 11007: INSERT INTO ff_formulas_f

11003: into l_ftype_id
11004: from ff_formula_types
11005: where formula_type_name = 'CAGR';
11006: --
11007: INSERT INTO ff_formulas_f
11008: (formula_id,
11009: effective_start_date,
11010: effective_end_date,
11011: business_group_id,

Line 11100: INSERT INTO ff_formulas_f

11096: into l_ftype_id
11097: from ff_formula_types
11098: where formula_type_name = 'Promotion';
11099: --
11100: INSERT INTO ff_formulas_f
11101: (formula_id,
11102: effective_start_date,
11103: effective_end_date,
11104: business_group_id,

Line 11136: FROM ff_formulas_f

11132: hr_utility.set_location ('hrstrdbi.insert_user_tables', 1);
11133: --
11134: BEGIN
11135: select formula_id into l_formula_id
11136: FROM ff_formulas_f
11137: WHERE formula_name = 'CHECK_RATE_TYPE'
11138: AND EFFECTIVE_START_DATE = to_date('01-01-0001', 'DD-MM-YYYY')
11139: AND EFFECTIVE_END_DATE = to_date('31-12-4712', 'DD-MM-YYYY');
11140: EXCEPTION