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_US_RSRW_UPGREV dependencies on STANDARD

Line 208: derived from the Work Schedule they are ASGigned to or by the Standard

204: Monthly earnings for salaried employees are processed every pay-period.
205: Salaried employees may or may not be required to submit a
206: timecard for days worked. If timecard is not required,
207: then the normal hours worked used for calculating employee pay are
208: derived from the Work Schedule they are ASGigned to or by the Standard
209: Hours entered on the ASGignment.
210:
211: The Monthly Salary input value will be boiled down to an hourly rate in
212: order to utilize the pro-ration capabilities of the system(Issue 1).

Line 285: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''

281: DEFAULT FOR TERMINATED_EMPLOYEE IS ''N''
282: DEFAULT FOR FINAL_PAY_PROCESSED IS ''N''
283: DEFAULT FOR PAYROLL_TERMINATION_TYPE IS ''L''
284: DEFAULT FOR BG_TERMINATION_TYPE IS ''L''
285: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''
286:
287: default for PAY_PROC_PERIOD_START_DATE is ''1900/01/01 00:00:00'' (DATE)
288: default for PAY_PROC_PERIOD_END_DATE is ''1900/01/02 00:00:00'' (DATE)
289: default for PAY_EARNED_START_DATE is ''1900/01/01 00:00:00'' (DATE)

Line 327: 2) standard hours on ASGignment as hours per week

323: prorate_end (date)
324:
325: /* Monthly salary must be converted to an hourly rate - using
326: 1) work schedule hours, or
327: 2) standard hours on ASGignment as hours per week
328: In either case, Convert_Period_Type function will handle it.
329:
330: At the Business Group and Organization level, termination
331: rule is determined which all terminated employees will

Line 336: or Last Standard Process Date. When no term rule is

332: follow for the payment. All existing payrolls and/or
333: business groups will be updated with Actual Termination
334: Date for the termination rule and for new Business Group
335: or payroll, user can decide whether to use Actual Term date
336: or Last Standard Process Date. When no term rule is
337: specified, it defaults to Last Standard Process date.
338:
339: The skip rule is changed so that for the New payroll or
340: business group created since July FP/2002, seeded skip

Line 337: specified, it defaults to Last Standard Process date.

333: business groups will be updated with Actual Termination
334: Date for the termination rule and for new Business Group
335: or payroll, user can decide whether to use Actual Term date
336: or Last Standard Process Date. When no term rule is
337: specified, it defaults to Last Standard Process date.
338:
339: The skip rule is changed so that for the New payroll or
340: business group created since July FP/2002, seeded skip
341: rule will skip element processing using LSP date and

Line 542: or Last Standard Process Date. When no term rule is

538: business groups (prior to July Family Pack 2002)
539: will be updated with Actual Termination Date for the
540: termination rule and for new Business Group
541: or payroll, user can decide whether to use Actual Term date
542: or Last Standard Process Date. When no term rule is
543: specified, it defaults to Last Standard Process date.
544: */
545:
546: IF regular_salaried_earnings < 0 THEN

Line 543: specified, it defaults to Last Standard Process date.

539: will be updated with Actual Termination Date for the
540: termination rule and for new Business Group
541: or payroll, user can decide whether to use Actual Term date
542: or Last Standard Process Date. When no term rule is
543: specified, it defaults to Last Standard Process date.
544: */
545:
546: IF regular_salaried_earnings < 0 THEN
547: (IF (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''A'' AND

Line 552: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')

548: TERMINATED_EMPLOYEE = ''Y'' AND FINAL_PAY_PROCESSED = ''N'') OR
549: (PAYROLL_TERMINATION_TYPE = ''A'' AND
550: TERMINATED_EMPLOYEE = ''Y'' AND FINAL_PAY_PROCESSED = ''N'') OR
551: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''L'' AND
552: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
553: OR
554: (PAYROLL_TERMINATION_TYPE = ''L'' AND
555: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
556: neg_earn = 0

Line 555: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN

551: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''L'' AND
552: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
553: OR
554: (PAYROLL_TERMINATION_TYPE = ''L'' AND
555: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
556: neg_earn = 0
557: ELSE
558: (neg_earn = regular_salaried_earnings - REGULAR_SALARY_NEG_EARNINGS_ASG_GRE_ITD
559: regular_salaried_earnings = 0

Line 710: derived from the Work Schedule they are ASGigned to or by the Standard

706: Monthly earnings for salaried employees are processed every pay-period.
707: Salaried employees may or may not be required to submit a
708: timecard for days worked. If timecard is not required,
709: then the normal hours worked used for calculating employee pay are
710: derived from the Work Schedule they are ASGigned to or by the Standard
711: Hours entered on the ASGignment.
712:
713: The Monthly Salary input value will be boiled down to an hourly rate in
714: order to utilize the pro-ration capabilities of the system(Issue 1).

Line 787: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''

783: DEFAULT FOR TERMINATED_EMPLOYEE IS ''N''
784: DEFAULT FOR FINAL_PAY_PROCESSED IS ''N''
785: DEFAULT FOR PAYROLL_TERMINATION_TYPE IS ''L''
786: DEFAULT FOR BG_TERMINATION_TYPE IS ''L''
787: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''
788:
789: default for PAY_PROC_PERIOD_START_DATE is ''1900/01/01 00:00:00'' (DATE)
790: default for PAY_PROC_PERIOD_END_DATE is ''1900/01/02 00:00:00'' (DATE)
791: default for PAY_EARNED_START_DATE is ''1900/01/01 00:00:00'' (DATE)

Line 821: 2) standard hours on ASGignment as hours per week

817: INPUTS ARE Monthly_Salary
818:
819: /* Monthly salary must be converted to an hourly rate - using
820: 1) work schedule hours, or
821: 2) standard hours on ASGignment as hours per week
822: In either case, Convert_Period_Type function will handle it.
823:
824:
825: At the Business Group and Organization level, termination

Line 831: or Last Standard Process Date. When no term rule is

827: follow for the payment. All existing payrolls and/or
828: business groups will be updated with Actual Termination
829: Date for the termination rule and for new Business Group
830: or payroll, user can decide whether to use Actual Term date
831: or Last Standard Process Date. When no term rule is
832: specified, it defaults to Last Standard Process date.
833:
834: The skip rule is changed so that for the New payroll or
835: business group created since July FP/2002, seeded skip

Line 832: specified, it defaults to Last Standard Process date.

828: business groups will be updated with Actual Termination
829: Date for the termination rule and for new Business Group
830: or payroll, user can decide whether to use Actual Term date
831: or Last Standard Process Date. When no term rule is
832: specified, it defaults to Last Standard Process date.
833:
834: The skip rule is changed so that for the New payroll or
835: business group created since July FP/2002, seeded skip
836: rule will skip element processing using LSP date and

Line 1019: or Last Standard Process Date. When no term rule is

1015: business groups (prior to July Family Pack 2002)
1016: will be updated with Actual Termination Date for the
1017: termination rule and for new Business Group
1018: or payroll, user can decide whether to use Actual Term date
1019: or Last Standard Process Date. When no term rule is
1020: specified, it defaults to Last Standard Process date.
1021: */
1022:
1023: IF regular_salaried_earnings < 0 THEN

Line 1020: specified, it defaults to Last Standard Process date.

1016: will be updated with Actual Termination Date for the
1017: termination rule and for new Business Group
1018: or payroll, user can decide whether to use Actual Term date
1019: or Last Standard Process Date. When no term rule is
1020: specified, it defaults to Last Standard Process date.
1021: */
1022:
1023: IF regular_salaried_earnings < 0 THEN
1024: (IF (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''A'' AND

Line 1029: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')

1025: TERMINATED_EMPLOYEE = ''Y'' AND FINAL_PAY_PROCESSED = ''N'') OR
1026: (PAYROLL_TERMINATION_TYPE = ''A'' AND
1027: TERMINATED_EMPLOYEE = ''Y'' AND FINAL_PAY_PROCESSED = ''N'') OR
1028: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''L'' AND
1029: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
1030: OR
1031: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1032: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
1033: THEN

Line 1032: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')

1028: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND BG_TERMINATION_TYPE = ''L'' AND
1029: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
1030: OR
1031: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1032: TERMINATED_EMPLOYEE = ''Y'' AND LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'')
1033: THEN
1034: neg_earn = 0
1035: ELSE
1036: (neg_earn = regular_salaried_earnings

Line 1204: - standard hours entered at the Organization and ASGignment levels.

1200: This rate is used with the number of hours worked to calculate earnings.
1201: Hours worked will be indicated by one of the following:
1202: - time entry or entries (ie. timecard)
1203: - ASGigned Work Schedule
1204: - standard hours entered at the Organization and ASGignment levels.
1205: For an Hourly-Timecard or "timecard required" employee, when a timecard
1206: is not submitted by the payroll input cutoff date - the wages for that
1207: employee will not be calculated and will have to wait for a subsequent
1208: payroll run for processing. When a timecard is submitted for an Hourly-

Line 1248: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''

1244: DEFAULT FOR TERMINATED_EMPLOYEE IS ''N''
1245: DEFAULT FOR FINAL_PAY_PROCESSED IS ''N''
1246: DEFAULT FOR PAYROLL_TERMINATION_TYPE IS ''L''
1247: DEFAULT FOR BG_TERMINATION_TYPE IS ''L''
1248: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''
1249: DEFAULT FOR LABOR_RECORDING_COUNT IS 0
1250: DEFAULT FOR USER_ENTERED_TIME IS ''N''
1251:
1252: default for PAY_PROC_PERIOD_START_DATE is ''1900/01/01 00:00:00'' (DATE)

Line 1405: or Last Standard Process Date. When no term rule is

1401: business groups (prior to July Family Pack 2002)
1402: will be updated with Actual Termination Date for the
1403: termination rule and for new Business Group
1404: or payroll, user can decide whether to use Actual Term date
1405: or Last Standard Process Date. When no term rule is
1406: specified, it defaults to Last Standard Process date.
1407: */
1408:
1409: t_sick_pay = calc_sick_pay(PAY_PROC_PERIOD_END_DATE

Line 1406: specified, it defaults to Last Standard Process date.

1402: will be updated with Actual Termination Date for the
1403: termination rule and for new Business Group
1404: or payroll, user can decide whether to use Actual Term date
1405: or Last Standard Process Date. When no term rule is
1406: specified, it defaults to Last Standard Process date.
1407: */
1408:
1409: t_sick_pay = calc_sick_pay(PAY_PROC_PERIOD_END_DATE
1410: ,PRORATE_START

Line 1511: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR

1507: FINAL_PAY_PROCESSED = ''N'') OR
1508: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND
1509: BG_TERMINATION_TYPE = ''L'' AND
1510: TERMINATED_EMPLOYEE = ''Y'' AND
1511: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR
1512: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1513: TERMINATED_EMPLOYEE = ''Y'' AND
1514: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
1515: neg_earn = 0

Line 1514: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN

1510: TERMINATED_EMPLOYEE = ''Y'' AND
1511: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR
1512: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1513: TERMINATED_EMPLOYEE = ''Y'' AND
1514: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
1515: neg_earn = 0
1516: ELSE
1517: (neg_earn = regular_wage_earnings
1518: regular_wage_earnings = 0

Line 1682: - standard hours entered at the Organization and ASGignment levels.

1678: This rate is used with the number of hours worked to calculate earnings.
1679: Hours worked will be indicated by one of the following:
1680: - time entry or entries (ie. timecard)
1681: - ASGigned Work Schedule
1682: - standard hours entered at the Organization and ASGignment levels.
1683: For an Hourly-Timecard or "timecard required" employee, when a timecard
1684: is not submitted by the payroll input cutoff date - the wages for that
1685: employee will not be calculated and will have to wait for a subsequent
1686: payroll run for processing. When a timecard is submitted for an Hourly-

Line 1726: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''

1722: DEFAULT FOR TERMINATED_EMPLOYEE IS ''N''
1723: DEFAULT FOR FINAL_PAY_PROCESSED IS ''N''
1724: DEFAULT FOR PAYROLL_TERMINATION_TYPE IS ''L''
1725: DEFAULT FOR BG_TERMINATION_TYPE IS ''L''
1726: default for LAST_STANDARD_PROCESS_DATE_PROCESSED IS ''N''
1727: DEFAULT FOR LABOR_RECORDING_COUNT IS 0
1728: DEFAULT FOR USER_ENTERED_TIME IS ''N''
1729:
1730: default for PAY_PROC_PERIOD_START_DATE is ''1900/01/01 00:00:00'' (DATE)

Line 1884: or Last Standard Process Date. When no term rule is

1880: business groups (prior to July Family Pack 2002)
1881: will be updated with Actual Termination Date for the
1882: termination rule and for new Business Group
1883: or payroll, user can decide whether to use Actual Term date
1884: or Last Standard Process Date. When no term rule is
1885: specified, it defaults to Last Standard Process date.
1886: */
1887:
1888: RED_REG_ADJUST_AMOUNT = 0.05

Line 1885: specified, it defaults to Last Standard Process date.

1881: will be updated with Actual Termination Date for the
1882: termination rule and for new Business Group
1883: or payroll, user can decide whether to use Actual Term date
1884: or Last Standard Process Date. When no term rule is
1885: specified, it defaults to Last Standard Process date.
1886: */
1887:
1888: RED_REG_ADJUST_AMOUNT = 0.05
1889: RED_REG_ADJUST_HOURS = 0.01

Line 1957: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR

1953: FINAL_PAY_PROCESSED = ''N'') OR
1954: (PAYROLL_TERMINATION_TYPE WAS DEFAULTED AND
1955: BG_TERMINATION_TYPE = ''L'' AND
1956: TERMINATED_EMPLOYEE = ''Y'' AND
1957: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR
1958: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1959: TERMINATED_EMPLOYEE = ''Y'' AND
1960: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
1961: neg_earn = 0

Line 1960: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN

1956: TERMINATED_EMPLOYEE = ''Y'' AND
1957: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') OR
1958: (PAYROLL_TERMINATION_TYPE = ''L'' AND
1959: TERMINATED_EMPLOYEE = ''Y'' AND
1960: LAST_STANDARD_PROCESS_DATE_PROCESSED = ''N'') THEN
1961: neg_earn = 0
1962: ELSE
1963: (neg_earn = regular_wage_earnings
1964: regular_wage_earnings = 0

Line 2781: fiscal year. This can be different from standard number

2777: /*****************************************************************************
2778: Name : get_payprd_per_fiscal_yr
2779:
2780: Description : This Function returns number of pay periods in the current
2781: fiscal year. This can be different from standard number
2782: of pay periods per fiscal year especially in case of
2783: "Weekly" and "Bi-Weekly" payroll.
2784: *****************************************************************************/
2785: