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_PAYROLL_ACTIONS

Line 74: g_action_typer pay_payroll_actions.action_type%TYPE;

70: g_ni_g_element_type_id number;
71: g_ni_j_element_type_id number;
72: g_ni_l_element_type_id number;
73: g_ni_s_element_type_id number;
74: g_action_typer pay_payroll_actions.action_type%TYPE;
75: g_action_typeq pay_payroll_actions.action_type%TYPE;
76: g_action_typeb pay_payroll_actions.action_type%TYPE;
77: g_balance number;
78:

Line 75: g_action_typeq pay_payroll_actions.action_type%TYPE;

71: g_ni_j_element_type_id number;
72: g_ni_l_element_type_id number;
73: g_ni_s_element_type_id number;
74: g_action_typer pay_payroll_actions.action_type%TYPE;
75: g_action_typeq pay_payroll_actions.action_type%TYPE;
76: g_action_typeb pay_payroll_actions.action_type%TYPE;
77: g_balance number;
78:
79: -- return the start of the span (year/quarter/week)

Line 76: g_action_typeb pay_payroll_actions.action_type%TYPE;

72: g_ni_l_element_type_id number;
73: g_ni_s_element_type_id number;
74: g_action_typer pay_payroll_actions.action_type%TYPE;
75: g_action_typeq pay_payroll_actions.action_type%TYPE;
76: g_action_typeb pay_payroll_actions.action_type%TYPE;
77: g_balance number;
78:
79: -- return the start of the span (year/quarter/week)
80: FUNCTION span_start(

Line 206: pay_payroll_actions ppa

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
210: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 246: pay_payroll_actions ppa

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
250: AND paa.source_action_id is null

Line 263: pay_payroll_actions ppa

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
267: AND paa.source_action_id is not null

Line 350: FROM pay_payroll_actions ppa,

346: l_effective_date date;
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: --

Line 551: pay_payroll_actions ppa,

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

Line 670: pay_payroll_actions BACT,

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
674: AND PTP.time_period_id = BACT.time_period_id

Line 2020: pay_payroll_actions ppa,

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

Line 2175: pay_payroll_actions ppa,

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

Line 2317: pay_payroll_actions ppa,

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

Line 2695: pay_payroll_actions ppa,

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

Line 3190: PACT PAY_PAYROLL_ACTIONS_PK,

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,
3194: TARGET PAY_RUN_RESULT_VALUES_PK) */

Line 3200: ,pay_payroll_actions PACT

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
3204: ,pay_run_result_values TARGET

Line 3488: pay_payroll_actions BACT

3484:
3485: SELECT PTP.regular_payment_date
3486: INTO l_regular_payment_date
3487: FROM per_time_periods PTP,
3488: pay_payroll_actions BACT
3489: WHERE BACT.payroll_action_id = p_owner_payroll_action_id
3490: AND PTP.time_period_id = BACT.time_period_id;
3491:
3492:

Line 3666: pay_payroll_actions bact,

3662: nvl(ent.original_entry_id, ent.element_entry_id) source_id
3663: from pay_element_entries_f ent,
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

Line 3698: , PAY_PAYROLL_ACTIONS PACT

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

Line 3728: , PAY_PAYROLL_ACTIONS PACT

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

Line 3769: from pay_payroll_actions pact

3765: and ptp.time_period_id in
3766: (
3767: select
3768: null
3769: from pay_payroll_actions pact
3770: where pact.action_type = 'I'
3771: );
3772: */
3773: --

Line 3779: pay_payroll_actions ppa

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: --
3783: l_ni_a_exists_adj number;

Line 3911: pay_payroll_actions bact,

3907: ,g_ni_l_element_type_id
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'