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.HR_GBBAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 205: FROM pay_assignment_actions paa,

201: l_assignment_id NUMBER;
202: --
203: cursor get_corr_type (c_assignment_action_id IN NUMBER) is
204: SELECT assignment_id
205: FROM pay_assignment_actions paa,
206: pay_payroll_actions ppa
207: WHERE
208: paa.assignment_action_id = c_assignment_action_id
209: AND ppa.payroll_action_id = paa.payroll_action_id

Line 245: FROM pay_assignment_actions paa,

241: c_effective_date IN DATE) is
242: SELECT /*+ USE_NL(paa, ppa) */
243: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
244: paa.assignment_action_id),16))
245: FROM pay_assignment_actions paa,
246: pay_payroll_actions ppa
247: WHERE
248: paa.assignment_id = c_assignment_id
249: AND ppa.payroll_action_id = paa.payroll_action_id

Line 262: FROM pay_assignment_actions paa,

258: c_master_asg_action_id IN NUMBER) is
259: SELECT /*+ USE_NL(paa, ppa) */
260: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
261: paa.assignment_action_id),16))
262: FROM pay_assignment_actions paa,
263: pay_payroll_actions ppa
264: WHERE
265: paa.assignment_id = c_assignment_id
266: AND ppa.payroll_action_id = paa.payroll_action_id

Line 351: pay_assignment_actions paa

347: --
348: cursor c_bal_date is
349: SELECT ppa.effective_date
350: FROM pay_payroll_actions ppa,
351: pay_assignment_actions paa
352: WHERE paa.payroll_action_id = ppa.payroll_action_id
353: AND paa.assignment_action_id = p_assignment_action_id;
354: --
355: begin

Line 552: pay_assignment_actions paa

548: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
549: SELECT ptp.end_date, ppa.effective_date
550: FROM per_time_periods ptp,
551: pay_payroll_actions ppa,
552: pay_assignment_actions paa
553: WHERE
554: paa.assignment_action_id = c_assignment_action_id
555: AND paa.payroll_action_id = ppa.payroll_action_id
556: AND ppa.time_period_id = ptp.time_period_id;

Line 669: pay_assignment_actions BAL_ASSACT,

665: BACT.effective_date,
666: PTP.regular_payment_date,
667: BACT.business_group_id
668: FROM
669: pay_assignment_actions BAL_ASSACT,
670: pay_payroll_actions BACT,
671: per_time_periods PTP
672: WHERE
673: BAL_ASSACT.assignment_action_id = p_assignment_action_id

Line 2021: pay_assignment_actions paa

2017: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2018: SELECT ptp.end_date, ppa.effective_date
2019: FROM per_time_periods ptp,
2020: pay_payroll_actions ppa,
2021: pay_assignment_actions paa
2022: WHERE
2023: paa.assignment_action_id = c_assignment_action_id
2024: AND paa.payroll_action_id = ppa.payroll_action_id
2025: AND ppa.time_period_id = ptp.time_period_id;

Line 2176: pay_assignment_actions paa

2172: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2173: SELECT ptp.end_date, ppa.effective_date
2174: FROM per_time_periods ptp,
2175: pay_payroll_actions ppa,
2176: pay_assignment_actions paa
2177: WHERE
2178: paa.assignment_action_id = c_assignment_action_id
2179: AND paa.payroll_action_id = ppa.payroll_action_id
2180: AND ppa.time_period_id = ptp.time_period_id;

Line 2318: pay_assignment_actions paa

2314: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2315: SELECT ptp.end_date, ppa.effective_date
2316: FROM per_time_periods ptp,
2317: pay_payroll_actions ppa,
2318: pay_assignment_actions paa
2319: WHERE
2320: paa.assignment_action_id = c_assignment_action_id
2321: AND paa.payroll_action_id = ppa.payroll_action_id
2322: AND ppa.time_period_id = ptp.time_period_id;

Line 2696: pay_assignment_actions paa

2692: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2693: SELECT ptp.end_date, ppa.effective_date
2694: FROM per_time_periods ptp,
2695: pay_payroll_actions ppa,
2696: pay_assignment_actions paa
2697: WHERE
2698: paa.assignment_action_id = c_assignment_action_id
2699: AND paa.payroll_action_id = ppa.payroll_action_id
2700: AND ppa.time_period_id = ptp.time_period_id;

Line 3189: SELECT /*+ ORDERED INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51,

3185: l_balance NUMBER;
3186: --
3187: BEGIN
3188: --
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,

Line 3199: pay_assignment_actions ASSACT

3195: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
3196: INTO
3197: l_balance
3198: FROM
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

Line 3648: FROM pay_assignment_actions paa

3644:
3645: cursor csr_child_asg_actid
3646: is
3647: SELECT max(paa.assignment_action_id)
3648: FROM pay_assignment_actions paa
3649: WHERE
3650: paa.source_action_id = p_assignment_action_id
3651: AND paa.source_action_id is not null;
3652:

Line 3668: pay_assignment_actions bassact

3664: pay_element_links_f pel,
3665: pay_user_rows_f urows,
3666: pay_payroll_actions bact,
3667: per_time_periods bptp,
3668: pay_assignment_actions bassact
3669: where bassact.assignment_action_id = p_assignment_action_id
3670: and UROWS.user_table_id = g_ni_cat_indicator_table_id
3671: and fnd_number.canonical_to_number(UROWS.ROW_LOW_RANGE_OR_NAME) = PEL.ELEMENT_TYPE_ID
3672: and g_start_of_year between

Line 3699: , PAY_ASSIGNMENT_ACTIONS ASSACT

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
3701: where PRR.source_id = p_source_id
3702: and PRR.source_type = 'I'
3703: AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID

Line 3700: , PAY_ASSIGNMENT_ACTIONS BASSACT

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
3701: where PRR.source_id = p_source_id
3702: and PRR.source_type = 'I'
3703: AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID
3704: AND PACT.ACTION_TYPE <> 'I'

Line 3729: , PAY_ASSIGNMENT_ACTIONS ASSACT

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
3731: WHERE FEED.balance_type_id in (
3732: g_ni_a_id, g_ni_a_able_id
3733: ,g_ni_b_id, g_ni_b_able_id

Line 3730: , PAY_ASSIGNMENT_ACTIONS BASSACT

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
3731: WHERE FEED.balance_type_id in (
3732: g_ni_a_id, g_ni_a_able_id
3733: ,g_ni_b_id, g_ni_b_able_id
3734: ,g_ni_c_id, g_ni_c_able_id

Line 3778: from pay_assignment_actions paa,

3774: cursor csr_asg_action_info (c_assignment_action_id IN NUMBER) IS
3775: select paa.assignment_id,
3776: paa.action_sequence,
3777: ppa.effective_date
3778: from pay_assignment_actions paa,
3779: pay_payroll_actions ppa
3780: where paa.assignment_action_id = c_assignment_action_id
3781: and paa.payroll_action_id = ppa.payroll_action_id;
3782: --

Line 3795: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3791: l_ni_l_exists_adj number;
3792: l_ni_s_exists_adj number;
3793:
3794: /*Added for bug fix 4088228*/
3795: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3796: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;
3797: v_master_exist varchar2(1);
3798:
3799: begin

Line 3796: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;

3792: l_ni_s_exists_adj number;
3793:
3794: /*Added for bug fix 4088228*/
3795: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3796: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;
3797: v_master_exist varchar2(1);
3798:
3799: begin
3800: --

Line 3912: pay_assignment_actions bassact

3908: ,g_ni_s_element_type_id
3909: from pay_element_types_f e,
3910: per_time_periods ptp,
3911: pay_payroll_actions bact,
3912: pay_assignment_actions bassact
3913: where element_name in ( 'NI'
3914: ,'NI A'
3915: ,'NI B'
3916: ,'NI C'

Line 4277: from pay_assignment_actions assact

4273: l_action_id := null;
4274: if (p_action_type in ('R','Q')) then
4275: select nvl(assact.source_action_id, assact.assignment_action_id)
4276: into l_action_id
4277: from pay_assignment_actions assact
4278: where assact.assignment_action_id = p_action_id;
4279: end if;
4280:
4281: return l_action_id;