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 6568: /* PER_SPINAL_POINT_PLACEMENTS_F */

6564: end;
6565: hr_utility.set_location(l_proc, 900);
6566: END PER_ALL_PEOPLE_F_ard;
6567:
6568: /* PER_SPINAL_POINT_PLACEMENTS_F */
6569: /* name : PER_SPINAL_POINT_PLCMTS_F_ard
6570: purpose : This is procedure that records any Delete on Spinal Point Placements.
6571: */
6572: --

Line 6598: 'PER_SPINAL_POINT_PLACEMENTS_F',

6594:
6595:
6596: pay_continuous_calc.event_update(p_business_group_id,
6597: p_legislation_code,
6598: 'PER_SPINAL_POINT_PLACEMENTS_F',
6599: null,
6600: null,
6601: null,
6602: p_old_effective_start_date,

Line 6664: 'PER_SPINAL_POINT_PLACEMENTS_F',

6660: --
6661:
6662: pay_continuous_calc.event_update(p_business_group_id,
6663: p_legislation_code,
6664: 'PER_SPINAL_POINT_PLACEMENTS_F',
6665: null,
6666: null,
6667: null,
6668: p_effective_start_date,

Line 8349: /* PER_SPINAL_POINT_PLACEMENTS_F */

8345: end;
8346: --
8347: end PER_ALL_PEOPLE_F_aru;
8348: --
8349: /* PER_SPINAL_POINT_PLACEMENTS_F */
8350: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru
8351: purpose : This is procedure that records any updates
8352: on spinal point placement.
8353: */

Line 8350: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru

8346: --
8347: end PER_ALL_PEOPLE_F_aru;
8348: --
8349: /* PER_SPINAL_POINT_PLACEMENTS_F */
8350: /* name : PER_SPINAL_POINT_PLACEMENTS_F_aru
8351: purpose : This is procedure that records any updates
8352: on spinal point placement.
8353: */
8354: procedure PER_SPIN_PNT_PLACEMENTS_F_aru(

Line 8399: 'PER_SPINAL_POINT_PLACEMENTS_F',

8395: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
8396: --
8397: pay_continuous_calc.event_update(p_business_group_id,
8398: p_legislation_code,
8399: 'PER_SPINAL_POINT_PLACEMENTS_F',
8400: 'ASSIGNMENT_ID',
8401: p_old_ASSIGNMENT_ID,
8402: p_new_ASSIGNMENT_ID,
8403: p_effective_date

Line 8408: 'PER_SPINAL_POINT_PLACEMENTS_F',

8404: );
8405: --
8406: pay_continuous_calc.event_update(p_business_group_id,
8407: p_legislation_code,
8408: 'PER_SPINAL_POINT_PLACEMENTS_F',
8409: 'AUTO_INCREMENT_FLAG',
8410: p_old_AUTO_INCREMENT_FLAG,
8411: p_new_AUTO_INCREMENT_FLAG,
8412: p_effective_date

Line 8417: 'PER_SPINAL_POINT_PLACEMENTS_F',

8413: );
8414: --
8415: pay_continuous_calc.event_update(p_business_group_id,
8416: p_legislation_code,
8417: 'PER_SPINAL_POINT_PLACEMENTS_F',
8418: 'BUSINESS_GROUP_ID',
8419: p_old_BUSINESS_GROUP_ID,
8420: p_new_BUSINESS_GROUP_ID,
8421: p_effective_date

Line 8426: 'PER_SPINAL_POINT_PLACEMENTS_F',

8422: );
8423: --
8424: pay_continuous_calc.event_update(p_business_group_id,
8425: p_legislation_code,
8426: 'PER_SPINAL_POINT_PLACEMENTS_F',
8427: 'PARENT_SPINE_ID',
8428: p_old_PARENT_SPINE_ID,
8429: p_new_PARENT_SPINE_ID,
8430: p_effective_date

Line 8435: 'PER_SPINAL_POINT_PLACEMENTS_F',

8431: );
8432: --
8433: pay_continuous_calc.event_update(p_business_group_id,
8434: p_legislation_code,
8435: 'PER_SPINAL_POINT_PLACEMENTS_F',
8436: 'PLACEMENT_ID',
8437: p_old_PLACEMENT_ID,
8438: p_new_PLACEMENT_ID,
8439: p_effective_date

Line 8444: 'PER_SPINAL_POINT_PLACEMENTS_F',

8440: );
8441: --
8442: pay_continuous_calc.event_update(p_business_group_id,
8443: p_legislation_code,
8444: 'PER_SPINAL_POINT_PLACEMENTS_F',
8445: 'PROGRAM_APPLICATION_ID',
8446: p_old_PROGRAM_APPLICATION_ID,
8447: p_new_PROGRAM_APPLICATION_ID,
8448: p_effective_date

Line 8453: 'PER_SPINAL_POINT_PLACEMENTS_F',

8449: );
8450: --
8451: pay_continuous_calc.event_update(p_business_group_id,
8452: p_legislation_code,
8453: 'PER_SPINAL_POINT_PLACEMENTS_F',
8454: 'PROGRAM_ID',
8455: p_old_PROGRAM_ID,
8456: p_new_PROGRAM_ID,
8457: p_effective_date

Line 8462: 'PER_SPINAL_POINT_PLACEMENTS_F',

8458: );
8459: --
8460: pay_continuous_calc.event_update(p_business_group_id,
8461: p_legislation_code,
8462: 'PER_SPINAL_POINT_PLACEMENTS_F',
8463: 'PROGRAM_UPDATE_DATE',
8464: p_old_PROGRAM_UPDATE_DATE,
8465: p_new_PROGRAM_UPDATE_DATE,
8466: p_effective_date

Line 8471: 'PER_SPINAL_POINT_PLACEMENTS_F',

8467: );
8468: --
8469: pay_continuous_calc.event_update(p_business_group_id,
8470: p_legislation_code,
8471: 'PER_SPINAL_POINT_PLACEMENTS_F',
8472: 'REASON',
8473: p_old_REASON,
8474: p_new_REASON,
8475: p_effective_date

Line 8480: 'PER_SPINAL_POINT_PLACEMENTS_F',

8476: );
8477: --
8478: pay_continuous_calc.event_update(p_business_group_id,
8479: p_legislation_code,
8480: 'PER_SPINAL_POINT_PLACEMENTS_F',
8481: 'REQUEST_ID',
8482: p_old_REQUEST_ID,
8483: p_new_REQUEST_ID,
8484: p_effective_date

Line 8489: 'PER_SPINAL_POINT_PLACEMENTS_F',

8485: );
8486: --
8487: pay_continuous_calc.event_update(p_business_group_id,
8488: p_legislation_code,
8489: 'PER_SPINAL_POINT_PLACEMENTS_F',
8490: 'STEP_ID',
8491: p_old_STEP_ID,
8492: p_new_STEP_ID,
8493: p_effective_date

Line 8498: 'PER_SPINAL_POINT_PLACEMENTS_F',

8494: );
8495: --
8496: pay_continuous_calc.event_update(p_business_group_id,
8497: p_legislation_code,
8498: 'PER_SPINAL_POINT_PLACEMENTS_F',
8499: 'STEP_ID',
8500: p_old_STEP_ID,
8501: p_new_STEP_ID,
8502: p_effective_date

Line 8509: 'PER_SPINAL_POINT_PLACEMENTS_F',

8505: /* OK it must be a date track change */
8506: --
8507: pay_continuous_calc.event_update(p_business_group_id,
8508: p_legislation_code,
8509: 'PER_SPINAL_POINT_PLACEMENTS_F',
8510: 'EFFECTIVE_END_DATE',
8511: p_old_EFFECTIVE_END_DATE,
8512: p_new_EFFECTIVE_END_DATE,
8513: p_new_effective_end_date,

Line 8520: 'PER_SPINAL_POINT_PLACEMENTS_F',

8516: );
8517: --
8518: pay_continuous_calc.event_update(p_business_group_id,
8519: p_legislation_code,
8520: 'PER_SPINAL_POINT_PLACEMENTS_F',
8521: 'EFFECTIVE_START_DATE',
8522: p_old_EFFECTIVE_START_DATE,
8523: p_new_EFFECTIVE_START_DATE,
8524: p_new_effective_start_date,

Line 11278: per_spinal_point_placements_f pspp

11274: from pay_grade_rules_f pgr,
11275: pay_assignment_actions paa,
11276: per_spinal_points psp,
11277: per_spinal_point_steps_f psps,
11278: per_spinal_point_placements_f pspp
11279: where paa.assignment_action_id = p_assignment_action_id
11280: and pgr.grade_rule_id = p_surrogate_key
11281: and p_date between pgr.effective_start_date
11282: and pgr.effective_end_date