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_CONTINUOUS_CALC dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 6600: /* PER_SPINAL_POINT_PLACEMENTS_F */

6596: end;
6597: hr_utility.set_location(l_proc, 900);
6598: END PER_ALL_PEOPLE_F_ard;
6599:
6600: /* PER_SPINAL_POINT_PLACEMENTS_F */
6601: /* name : PER_SPINAL_POINT_PLCMTS_F_ard
6602: purpose : This is procedure that records any Delete on Spinal Point Placements.
6603: */
6604: --

Line 6630: 'PER_SPINAL_POINT_PLACEMENTS_F',

6626:
6627:
6628: pay_continuous_calc.event_update(p_business_group_id,
6629: p_legislation_code,
6630: 'PER_SPINAL_POINT_PLACEMENTS_F',
6631: null,
6632: null,
6633: null,
6634: p_old_effective_start_date,

Line 6696: 'PER_SPINAL_POINT_PLACEMENTS_F',

6692: --
6693:
6694: pay_continuous_calc.event_update(p_business_group_id,
6695: p_legislation_code,
6696: 'PER_SPINAL_POINT_PLACEMENTS_F',
6697: null,
6698: null,
6699: null,
6700: p_effective_start_date,

Line 8381: /* PER_SPINAL_POINT_PLACEMENTS_F */

8377: end;
8378: --
8379: end PER_ALL_PEOPLE_F_aru;
8380: --
8381: /* PER_SPINAL_POINT_PLACEMENTS_F */
8382: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru
8383: purpose : This is procedure that records any updates
8384: on spinal point placement.
8385: */

Line 8382: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru

8378: --
8379: end PER_ALL_PEOPLE_F_aru;
8380: --
8381: /* PER_SPINAL_POINT_PLACEMENTS_F */
8382: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru
8383: purpose : This is procedure that records any updates
8384: on spinal point placement.
8385: */
8386: procedure PER_SPIN_PNT_PLACEMENTS_F_aru(

Line 8431: 'PER_SPINAL_POINT_PLACEMENTS_F',

8427: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
8428: --
8429: pay_continuous_calc.event_update(p_business_group_id,
8430: p_legislation_code,
8431: 'PER_SPINAL_POINT_PLACEMENTS_F',
8432: 'ASSIGNMENT_ID',
8433: p_old_ASSIGNMENT_ID,
8434: p_new_ASSIGNMENT_ID,
8435: p_effective_date

Line 8440: 'PER_SPINAL_POINT_PLACEMENTS_F',

8436: );
8437: --
8438: pay_continuous_calc.event_update(p_business_group_id,
8439: p_legislation_code,
8440: 'PER_SPINAL_POINT_PLACEMENTS_F',
8441: 'AUTO_INCREMENT_FLAG',
8442: p_old_AUTO_INCREMENT_FLAG,
8443: p_new_AUTO_INCREMENT_FLAG,
8444: p_effective_date

Line 8449: 'PER_SPINAL_POINT_PLACEMENTS_F',

8445: );
8446: --
8447: pay_continuous_calc.event_update(p_business_group_id,
8448: p_legislation_code,
8449: 'PER_SPINAL_POINT_PLACEMENTS_F',
8450: 'BUSINESS_GROUP_ID',
8451: p_old_BUSINESS_GROUP_ID,
8452: p_new_BUSINESS_GROUP_ID,
8453: p_effective_date

Line 8458: 'PER_SPINAL_POINT_PLACEMENTS_F',

8454: );
8455: --
8456: pay_continuous_calc.event_update(p_business_group_id,
8457: p_legislation_code,
8458: 'PER_SPINAL_POINT_PLACEMENTS_F',
8459: 'PARENT_SPINE_ID',
8460: p_old_PARENT_SPINE_ID,
8461: p_new_PARENT_SPINE_ID,
8462: p_effective_date

Line 8467: 'PER_SPINAL_POINT_PLACEMENTS_F',

8463: );
8464: --
8465: pay_continuous_calc.event_update(p_business_group_id,
8466: p_legislation_code,
8467: 'PER_SPINAL_POINT_PLACEMENTS_F',
8468: 'PLACEMENT_ID',
8469: p_old_PLACEMENT_ID,
8470: p_new_PLACEMENT_ID,
8471: p_effective_date

Line 8476: 'PER_SPINAL_POINT_PLACEMENTS_F',

8472: );
8473: --
8474: pay_continuous_calc.event_update(p_business_group_id,
8475: p_legislation_code,
8476: 'PER_SPINAL_POINT_PLACEMENTS_F',
8477: 'PROGRAM_APPLICATION_ID',
8478: p_old_PROGRAM_APPLICATION_ID,
8479: p_new_PROGRAM_APPLICATION_ID,
8480: p_effective_date

Line 8485: 'PER_SPINAL_POINT_PLACEMENTS_F',

8481: );
8482: --
8483: pay_continuous_calc.event_update(p_business_group_id,
8484: p_legislation_code,
8485: 'PER_SPINAL_POINT_PLACEMENTS_F',
8486: 'PROGRAM_ID',
8487: p_old_PROGRAM_ID,
8488: p_new_PROGRAM_ID,
8489: p_effective_date

Line 8494: 'PER_SPINAL_POINT_PLACEMENTS_F',

8490: );
8491: --
8492: pay_continuous_calc.event_update(p_business_group_id,
8493: p_legislation_code,
8494: 'PER_SPINAL_POINT_PLACEMENTS_F',
8495: 'PROGRAM_UPDATE_DATE',
8496: p_old_PROGRAM_UPDATE_DATE,
8497: p_new_PROGRAM_UPDATE_DATE,
8498: p_effective_date

Line 8503: 'PER_SPINAL_POINT_PLACEMENTS_F',

8499: );
8500: --
8501: pay_continuous_calc.event_update(p_business_group_id,
8502: p_legislation_code,
8503: 'PER_SPINAL_POINT_PLACEMENTS_F',
8504: 'REASON',
8505: p_old_REASON,
8506: p_new_REASON,
8507: p_effective_date

Line 8512: 'PER_SPINAL_POINT_PLACEMENTS_F',

8508: );
8509: --
8510: pay_continuous_calc.event_update(p_business_group_id,
8511: p_legislation_code,
8512: 'PER_SPINAL_POINT_PLACEMENTS_F',
8513: 'REQUEST_ID',
8514: p_old_REQUEST_ID,
8515: p_new_REQUEST_ID,
8516: p_effective_date

Line 8521: 'PER_SPINAL_POINT_PLACEMENTS_F',

8517: );
8518: --
8519: pay_continuous_calc.event_update(p_business_group_id,
8520: p_legislation_code,
8521: 'PER_SPINAL_POINT_PLACEMENTS_F',
8522: 'STEP_ID',
8523: p_old_STEP_ID,
8524: p_new_STEP_ID,
8525: p_effective_date

Line 8530: 'PER_SPINAL_POINT_PLACEMENTS_F',

8526: );
8527: --
8528: pay_continuous_calc.event_update(p_business_group_id,
8529: p_legislation_code,
8530: 'PER_SPINAL_POINT_PLACEMENTS_F',
8531: 'STEP_ID',
8532: p_old_STEP_ID,
8533: p_new_STEP_ID,
8534: p_effective_date

Line 8541: 'PER_SPINAL_POINT_PLACEMENTS_F',

8537: /* OK it must be a date track change */
8538: --
8539: pay_continuous_calc.event_update(p_business_group_id,
8540: p_legislation_code,
8541: 'PER_SPINAL_POINT_PLACEMENTS_F',
8542: 'EFFECTIVE_END_DATE',
8543: p_old_EFFECTIVE_END_DATE,
8544: p_new_EFFECTIVE_END_DATE,
8545: p_new_effective_end_date,

Line 8552: 'PER_SPINAL_POINT_PLACEMENTS_F',

8548: );
8549: --
8550: pay_continuous_calc.event_update(p_business_group_id,
8551: p_legislation_code,
8552: 'PER_SPINAL_POINT_PLACEMENTS_F',
8553: 'EFFECTIVE_START_DATE',
8554: p_old_EFFECTIVE_START_DATE,
8555: p_new_EFFECTIVE_START_DATE,
8556: p_new_effective_start_date,

Line 11310: per_spinal_point_placements_f pspp

11306: from pay_grade_rules_f pgr,
11307: pay_assignment_actions paa,
11308: per_spinal_points psp,
11309: per_spinal_point_steps_f psps,
11310: per_spinal_point_placements_f pspp
11311: where paa.assignment_action_id = p_assignment_action_id
11312: and pgr.grade_rule_id = p_surrogate_key
11313: and p_date between pgr.effective_start_date
11314: and pgr.effective_end_date