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 2014: pay_payroll_actions ppa,

2010: --
2011: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2012: SELECT ptp.end_date, ppa.effective_date
2013: FROM per_time_periods ptp,
2014: pay_payroll_actions ppa,
2015: pay_assignment_actions paa
2016: WHERE
2017: paa.assignment_action_id = c_assignment_action_id
2018: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2169: pay_payroll_actions ppa,

2165: --
2166: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2167: SELECT ptp.end_date, ppa.effective_date
2168: FROM per_time_periods ptp,
2169: pay_payroll_actions ppa,
2170: pay_assignment_actions paa
2171: WHERE
2172: paa.assignment_action_id = c_assignment_action_id
2173: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2311: pay_payroll_actions ppa,

2307: --
2308: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2309: SELECT ptp.end_date, ppa.effective_date
2310: FROM per_time_periods ptp,
2311: pay_payroll_actions ppa,
2312: pay_assignment_actions paa
2313: WHERE
2314: paa.assignment_action_id = c_assignment_action_id
2315: AND paa.payroll_action_id = ppa.payroll_action_id

Line 2689: pay_payroll_actions ppa,

2685: --
2686: cursor expired_time_period (c_assignment_action_id IN NUMBER) is
2687: SELECT ptp.end_date, ppa.effective_date
2688: FROM per_time_periods ptp,
2689: pay_payroll_actions ppa,
2690: pay_assignment_actions paa
2691: WHERE
2692: paa.assignment_action_id = c_assignment_action_id
2693: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3184: PACT PAY_PAYROLL_ACTIONS_PK,

3180: --
3181: BEGIN
3182: --
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) */

Line 3194: ,pay_payroll_actions PACT

3190: INTO
3191: l_balance
3192: FROM
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

Line 3583: pay_payroll_actions bact,

3579: nvl(ent.original_entry_id, ent.element_entry_id) source_id
3580: from pay_element_entries_f ent,
3581: pay_element_links_f pel,
3582: pay_user_rows_f urows,
3583: pay_payroll_actions bact,
3584: per_time_periods bptp,
3585: pay_assignment_actions bassact
3586: where bassact.assignment_action_id = p_assignment_action_id
3587: and UROWS.user_table_id = g_ni_cat_indicator_table_id

Line 3615: , PAY_PAYROLL_ACTIONS PACT

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

Line 3645: , PAY_PAYROLL_ACTIONS PACT

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

Line 3686: from pay_payroll_actions pact

3682: and ptp.time_period_id in
3683: (
3684: select
3685: null
3686: from pay_payroll_actions pact
3687: where pact.action_type = 'I'
3688: );
3689: */
3690: --

Line 3696: pay_payroll_actions ppa

3692: select paa.assignment_id,
3693: paa.action_sequence,
3694: ppa.effective_date
3695: from pay_assignment_actions paa,
3696: pay_payroll_actions ppa
3697: where paa.assignment_action_id = c_assignment_action_id
3698: and paa.payroll_action_id = ppa.payroll_action_id;
3699: --
3700: l_ni_a_exists_adj number;

Line 3828: pay_payroll_actions bact,

3824: ,g_ni_l_element_type_id
3825: ,g_ni_s_element_type_id
3826: from pay_element_types_f e,
3827: per_time_periods ptp,
3828: pay_payroll_actions bact,
3829: pay_assignment_actions bassact
3830: where element_name in ( 'NI'
3831: ,'NI A'
3832: ,'NI B'