APPS.HR_GBBAL dependencies on PAY_RUN_RESULTS

Line 1148: from pay_run_results rr,

1144: and (ffc.context_name = p_context_01 OR ffc.context_name = p_context_02)
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

Line 3187: RR PAY_RUN_RESULTS_N50,

3183: SELECT /*+ ORDERED INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
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

Line 3197: ,pay_run_results RR

3193: pay_assignment_actions ASSACT
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

Line 3469: pay_run_results prr,

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
3473: AND iv.name = 'Reference'

Line 3478: FROM pay_run_results prr

3474: AND iv.input_value_id = prrv.input_value_id;
3475:
3476: cursor get_source_id(c_run_result_id NUMBER) IS
3477: SELECT prr.source_id
3478: FROM pay_run_results prr
3479: WHERE prr.run_result_id = c_run_result_id;
3480:
3481: --
3482: BEGIN

Line 3613: PAY_RUN_RESULTS PRR

3609: , max(decode(PRR.element_type_id,g_ni_j_element_type_id,1,0))
3610: , max(decode(PRR.element_type_id,g_ni_l_element_type_id,1,0))
3611: , max(decode(PRR.element_type_id,g_ni_s_element_type_id,1,0))
3612: from
3613: PAY_RUN_RESULTS PRR
3614: , PER_TIME_PERIODS PPTP
3615: , PAY_PAYROLL_ACTIONS PACT
3616: , PAY_ASSIGNMENT_ACTIONS ASSACT
3617: , PAY_ASSIGNMENT_ACTIONS BASSACT

Line 3643: , PAY_RUN_RESULTS PRR

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
3647: , PAY_ASSIGNMENT_ACTIONS BASSACT