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 3193: RR PAY_RUN_RESULTS_N50,

3189: SELECT /*+ ORDERED INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51,
3190: PACT PAY_PAYROLL_ACTIONS_PK,
3191: FEED PAY_BALANCE_FEEDS_F_UK2,
3192: PPTP PER_TIME_PERIODS_PK,
3193: RR PAY_RUN_RESULTS_N50,
3194: TARGET PAY_RUN_RESULT_VALUES_PK) */
3195: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
3196: INTO
3197: l_balance

Line 3203: ,pay_run_results RR

3199: pay_assignment_actions ASSACT
3200: ,pay_payroll_actions PACT
3201: ,pay_balance_feeds_f FEED
3202: ,per_time_periods PPTP
3203: ,pay_run_results RR
3204: ,pay_run_result_values TARGET
3205: WHERE
3206: FEED.balance_type_id = P_BALANCE_TYPE_ID
3207: AND FEED.input_value_id = TARGET.input_value_id

Line 3552: pay_run_results prr,

3548: --
3549: cursor get_run_result_value (c_run_result_id NUMBER) is
3550: SELECT prrv.result_value
3551: FROM pay_run_result_values prrv,
3552: pay_run_results prr,
3553: pay_input_values iv
3554: WHERE prr.run_result_id = c_run_result_id
3555: AND prr.run_result_id = prrv.run_result_id
3556: AND iv.name = 'Reference'

Line 3561: FROM pay_run_results prr

3557: AND iv.input_value_id = prrv.input_value_id;
3558:
3559: cursor get_source_id(c_run_result_id NUMBER) IS
3560: SELECT prr.source_id
3561: FROM pay_run_results prr
3562: WHERE prr.run_result_id = c_run_result_id;
3563:
3564: --
3565: BEGIN

Line 3696: PAY_RUN_RESULTS PRR

3692: , max(decode(PRR.element_type_id,g_ni_j_element_type_id,1,0))
3693: , max(decode(PRR.element_type_id,g_ni_l_element_type_id,1,0))
3694: , max(decode(PRR.element_type_id,g_ni_s_element_type_id,1,0))
3695: from
3696: PAY_RUN_RESULTS PRR
3697: , PER_TIME_PERIODS PPTP
3698: , PAY_PAYROLL_ACTIONS PACT
3699: , PAY_ASSIGNMENT_ACTIONS ASSACT
3700: , PAY_ASSIGNMENT_ACTIONS BASSACT

Line 3726: , PAY_RUN_RESULTS PRR

3722: , max(decode(FEED.balance_type_id,g_ni_s_id,1,g_ni_s_able_id,1,0))
3723: from
3724: PAY_BALANCE_FEEDS_F FEED
3725: , PAY_RUN_RESULT_VALUES PRRV
3726: , PAY_RUN_RESULTS PRR
3727: , PER_TIME_PERIODS PPTP
3728: , PAY_PAYROLL_ACTIONS PACT
3729: , PAY_ASSIGNMENT_ACTIONS ASSACT
3730: , PAY_ASSIGNMENT_ACTIONS BASSACT