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 2015: pay_assignment_actions paa

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
2019: AND ppa.time_period_id = ptp.time_period_id;

Line 2170: pay_assignment_actions paa

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
2174: AND ppa.time_period_id = ptp.time_period_id;

Line 2312: pay_assignment_actions paa

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
2316: AND ppa.time_period_id = ptp.time_period_id;

Line 2690: pay_assignment_actions paa

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
2694: AND ppa.time_period_id = ptp.time_period_id;

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

3179: l_balance NUMBER;
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,

Line 3193: pay_assignment_actions ASSACT

3189: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
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

Line 3565: FROM pay_assignment_actions paa

3561:
3562: cursor csr_child_asg_actid
3563: is
3564: SELECT max(paa.assignment_action_id)
3565: FROM pay_assignment_actions paa
3566: WHERE
3567: paa.source_action_id = p_assignment_action_id
3568: AND paa.source_action_id is not null;
3569:

Line 3585: pay_assignment_actions bassact

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
3588: and fnd_number.canonical_to_number(UROWS.ROW_LOW_RANGE_OR_NAME) = PEL.ELEMENT_TYPE_ID
3589: and g_start_of_year between

Line 3616: , PAY_ASSIGNMENT_ACTIONS ASSACT

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'
3620: AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID

Line 3617: , PAY_ASSIGNMENT_ACTIONS BASSACT

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'
3620: AND PACT.PAYROLL_ACTION_ID = ASSACT.PAYROLL_ACTION_ID
3621: AND PACT.ACTION_TYPE <> 'I'

Line 3646: , PAY_ASSIGNMENT_ACTIONS ASSACT

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
3650: ,g_ni_b_id, g_ni_b_able_id

Line 3647: , PAY_ASSIGNMENT_ACTIONS BASSACT

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
3650: ,g_ni_b_id, g_ni_b_able_id
3651: ,g_ni_c_id, g_ni_c_able_id

Line 3695: from pay_assignment_actions paa,

3691: cursor csr_asg_action_info (c_assignment_action_id IN NUMBER) IS
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: --

Line 3712: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3708: l_ni_l_exists_adj number;
3709: l_ni_s_exists_adj number;
3710:
3711: /*Added for bug fix 4088228*/
3712: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3713: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;
3714: v_master_exist varchar2(1);
3715:
3716: begin

Line 3713: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;

3709: l_ni_s_exists_adj number;
3710:
3711: /*Added for bug fix 4088228*/
3712: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3713: p_assignment_action_id_child pay_assignment_actions.assignment_action_id%TYPE;
3714: v_master_exist varchar2(1);
3715:
3716: begin
3717: --

Line 3829: pay_assignment_actions bassact

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'
3833: ,'NI C'

Line 4194: from pay_assignment_actions assact

4190: l_action_id := null;
4191: if (p_action_type in ('R','Q')) then
4192: select nvl(assact.source_action_id, assact.assignment_action_id)
4193: into l_action_id
4194: from pay_assignment_actions assact
4195: where assact.assignment_action_id = p_action_id;
4196: end if;
4197:
4198: return l_action_id;