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_AU_PAYE_FF dependencies on PAY_RUN_RESULTS

Line 1491: pay_run_results prr,

1487: SELECT ptp.start_date,ptp.end_date
1488: FROM per_time_periods ptp,
1489: pay_payroll_actions ppa,
1490: pay_assignment_actions paa,
1491: pay_run_results prr,
1492: pay_element_entries_f pee
1493: WHERE pee.element_entry_id=c_element_entry_id
1494: and prr.run_result_id = pee.source_id
1495: and paa.assignment_action_id=prr.assignment_action_id

Line 1636: pay_run_results prr,

1632: ,ppa.effective_date
1633: FROM per_time_periods ptp,
1634: pay_payroll_actions ppa,
1635: pay_assignment_actions paa,
1636: pay_run_results prr,
1637: pay_element_entries_f pee
1638: WHERE pee.element_entry_id=c_element_entry_id
1639: AND prr.run_result_id = pee.source_id
1640: AND paa.assignment_action_id=prr.assignment_action_id

Line 2811: pay_run_results prr,

2807: from
2808: pay_element_types_f pet,
2809: pay_input_values_f piv,
2810: pay_run_result_values prrv,
2811: pay_run_results prr,
2812: pay_assignment_actions paa,
2813: pay_payroll_actions ppa,
2814: per_time_periods ptp,
2815: per_all_assignments_f paaf

Line 3066: from pay_run_results prr,

3062: l_procedure varchar2(80);
3063:
3064: CURSOR Cr_value IS (
3065: SELECT prv.result_value
3066: from pay_run_results prr,
3067: pay_run_result_values prv,
3068: pay_element_types_f pet,
3069: pay_input_values_f piv
3070: where prr.assignment_action_id = p_assignment_action_id

Line 3253: pay_run_results prr,

3249: select prv.RESULT_VALUE period_spread_over, prr.run_result_id, pee.creator_type
3250: from pay_element_types_f pet,
3251: pay_input_values_f piv,
3252: pay_run_result_values prv,
3253: pay_run_results prr,
3254: pay_element_entries_f pee
3255: where prr.assignment_action_id=p_assignment_action_id
3256: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3257: and prv.input_value_id = piv.input_value_id

Line 3271: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is

3267: and p_date_paid between pet.effective_start_date and pet.effective_end_date
3268: and p_date_paid between piv.effective_start_date and piv.effective_end_date
3269: and p_date_paid between pee.effective_start_date and pee.effective_end_date;
3270:
3271: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
3272: select prv.RESULT_VALUE
3273: from pay_input_values_f piv,
3274: pay_run_result_values prv,
3275: pay_run_results prr

Line 3275: pay_run_results prr

3271: cursor get_spread_earning(p_run_result_id pay_run_results.run_result_id%type) is
3272: select prv.RESULT_VALUE
3273: from pay_input_values_f piv,
3274: pay_run_result_values prv,
3275: pay_run_results prr
3276: where prr.RUN_RESULT_ID = p_run_result_id
3277: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3278: and prv.input_value_id = piv.input_value_id
3279: and piv.name ='Total Payment'

Line 3289: pay_run_results prr,

3285: select nvl(sum(prv.RESULT_VALUE),0)
3286: from pay_element_types_f pet,
3287: pay_input_values_f piv,
3288: pay_run_result_values prv,
3289: pay_run_results prr,
3290: pay_element_entries_f pee
3291: where prr.assignment_action_id=p_assignment_action_id
3292: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3293: and prv.input_value_id = piv.input_value_id

Line 3401: pay_run_results prr,

3397: select nvl(sum(prv.RESULT_VALUE),0)
3398: from pay_element_types_f pet,
3399: pay_input_values_f piv,
3400: pay_run_result_values prv,
3401: pay_run_results prr,
3402: pay_element_entries_f pee
3403: where prr.assignment_action_id=p_assignment_action_id
3404: and prr.RUN_RESULT_ID = prv.RUN_RESULT_ID
3405: and prv.input_value_id = piv.input_value_id

Line 3537: from pay_run_results prr,

3533:
3534: CURSOR check_avg_earnings(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
3535: IS
3536: select prv.result_value
3537: from pay_run_results prr,
3538: pay_run_result_values prv,
3539: pay_element_types_f pet,
3540: pay_input_values_f piv
3541: where prr.assignment_action_id = c_assignment_action_id

Line 3770: FROM pay_run_results prr

3766: ,c_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3767: ,c_date_earned IN DATE )
3768: IS
3769: SELECT prrv.result_value
3770: FROM pay_run_results prr
3771: ,pay_run_result_values prrv
3772: ,pay_input_values_f pivf
3773: ,pay_element_entries_f pee
3774: WHERE pee.element_entry_id = c_element_entry_id

Line 4117: , pay_run_results prr

4113: SELECT SUM(NVL(TARGET.result_value,0))
4114: FROM
4115: pay_balance_feeds_f FEED
4116: , pay_run_result_values TARGET
4117: , pay_run_results prr
4118: , pay_payroll_actions ppa
4119: , pay_assignment_actions paa
4120: , pay_payroll_actions ppas
4121: , pay_assignment_actions paas

Line 4223: from pay_run_results prr,

4219: return number IS
4220:
4221: cursor get_retro_spread is
4222: select prv.result_value
4223: from pay_run_results prr,
4224: pay_run_result_values prv,
4225: pay_input_values_f piv,
4226: pay_element_types_f pet
4227: where prr.assignment_action_id = p_assignment_action_id

Line 4247: from pay_run_results prr,

4243: AND paa.action_status = 'B';
4244:
4245: cursor get_retro_total is
4246: select prv.result_value
4247: from pay_run_results prr,
4248: pay_run_result_values prv,
4249: pay_input_values_f piv,
4250: pay_element_types_f pet
4251: where prr.assignment_action_id = p_assignment_action_id