APPS.HR_GBBAL dependencies on PAY_RUN_RESULT_VALUES

Line 1149: pay_run_result_values rrv,

1145: and (ffc.context_name <> 'SOURCE_TEXT'
1146: or (ffc.context_name = 'SOURCE_TEXT' AND
1147: exists ( select 1
1148: from pay_run_results rr,
1149: pay_run_result_values rrv,
1150: pay_input_values_f piv,
1151: pay_element_types_f petf
1152: where rr.assignment_action_id = pca.assignment_action_id
1153: and rr.element_type_id = petf.element_type_id

Line 3188: TARGET PAY_RUN_RESULT_VALUES_PK) */

3184: PACT PAY_PAYROLL_ACTIONS_PK,
3185: FEED PAY_BALANCE_FEEDS_F_UK2,
3186: PPTP PER_TIME_PERIODS_PK,
3187: RR PAY_RUN_RESULTS_N50,
3188: TARGET PAY_RUN_RESULT_VALUES_PK) */
3189: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
3190: INTO
3191: l_balance
3192: FROM

Line 3198: ,pay_run_result_values TARGET

3194: ,pay_payroll_actions PACT
3195: ,pay_balance_feeds_f FEED
3196: ,per_time_periods PPTP
3197: ,pay_run_results RR
3198: ,pay_run_result_values TARGET
3199: WHERE
3200: FEED.balance_type_id = P_BALANCE_TYPE_ID
3201: AND FEED.input_value_id = TARGET.input_value_id
3202: AND TARGET.run_result_id = RR.run_result_id

Line 3468: FROM pay_run_result_values prrv,

3464: l_original_entry_id number;
3465: --
3466: cursor get_run_result_value (c_run_result_id NUMBER) is
3467: SELECT prrv.result_value
3468: FROM pay_run_result_values prrv,
3469: pay_run_results prr,
3470: pay_input_values iv
3471: WHERE prr.run_result_id = c_run_result_id
3472: AND prr.run_result_id = prrv.run_result_id

Line 3642: , PAY_RUN_RESULT_VALUES PRRV

3638: , max(decode(FEED.balance_type_id,g_ni_l_id,1,g_ni_l_able_id,1,0))
3639: , max(decode(FEED.balance_type_id,g_ni_s_id,1,g_ni_s_able_id,1,0))
3640: from
3641: PAY_BALANCE_FEEDS_F FEED
3642: , PAY_RUN_RESULT_VALUES PRRV
3643: , PAY_RUN_RESULTS PRR
3644: , PER_TIME_PERIODS PPTP
3645: , PAY_PAYROLL_ACTIONS PACT
3646: , PAY_ASSIGNMENT_ACTIONS ASSACT