APPS.PAY_AU_PAYE_FF dependencies on PAY_RUN_RESULT_VALUES

Line 2810: pay_run_result_values prrv,

2806: select 'Y'
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,

Line 3067: pay_run_result_values prv,

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
3071: and prv.run_result_id = prr.run_result_id

Line 3252: pay_run_result_values prv,

3248: cursor get_period_spread_over is
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

Line 3274: pay_run_result_values prv,

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
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

Line 3288: pay_run_result_values prv,

3284: cursor get_retro_spread_earning is
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

Line 3400: pay_run_result_values prv,

3396: cursor get_retro_spread_earning is
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

Line 3538: pay_run_result_values prv,

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
3542: and prr.element_type_id = pet.element_type_id

Line 3771: ,pay_run_result_values prrv

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
3775: AND pee.assignment_id = c_assignment_id

Line 4116: , pay_run_result_values TARGET

4112: IS
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

Line 4224: pay_run_result_values prv,

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
4228: and prr.run_result_id = prv.run_result_id

Line 4248: pay_run_result_values prv,

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
4252: and prr.run_result_id = prv.run_result_id