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 PER_TIME_PERIODS

Line 5: g_start_of_year per_time_periods.regular_payment_date%type;

1: PACKAGE BODY hr_gbbal AS
2: /* $Header: pygbbal.pkb 120.6.12000000.4 2007/09/03 12:55:30 ajeyam noship $ */
3: --------------------------------------------------------------------------------
4: g_assignment_action_id number;
5: g_start_of_year per_time_periods.regular_payment_date%type;
6: -- g_initialization_exists number;
7: g_asg_td_ytd number;
8: g_assignment_action_id2 number;
9: g_assignment_id number;

Line 550: FROM per_time_periods ptp,

546: p_effective_date in date) return number is
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

Line 671: per_time_periods PTP

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
675: AND BACT.payroll_action_id = BAL_ASSACT.payroll_action_id;

Line 2013: FROM per_time_periods ptp,

2009: -- Has the processing time period expired
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

Line 2168: FROM per_time_periods ptp,

2164: l_date_paid DATE;
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

Line 2310: FROM per_time_periods ptp,

2306: l_date_paid DATE;
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

Line 2688: FROM per_time_periods ptp,

2684: -- Has the processing time period expired
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

Line 3186: PPTP PER_TIME_PERIODS_PK,

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

Line 3196: ,per_time_periods PPTP

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
3199: WHERE
3200: FEED.balance_type_id = P_BALANCE_TYPE_ID

Line 3553: l_regular_payment_date per_time_periods.regular_payment_date%type;

3549: function ni_category_exists_in_year (p_assignment_action_id in number,
3550: p_category in varchar2)
3551: RETURN number is
3552: l_return number;
3553: l_regular_payment_date per_time_periods.regular_payment_date%type;
3554: l_niable_def_id pay_defined_balances.defined_balance_id%type;
3555: l_nitotal_def_id pay_defined_balances.defined_balance_id%type;
3556: l_nitotal_value number;
3557: l_niable_value number;

Line 3584: per_time_periods bptp,

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

Line 3614: , PER_TIME_PERIODS PPTP

3610: , max(decode(PRR.element_type_id,g_ni_l_element_type_id,1,0))
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

Line 3644: , PER_TIME_PERIODS PPTP

3640: from
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 (

Line 3680: from per_time_periods ptp

3676: --Remove this cursor for bug 4120063
3677: /*
3678: cursor CSR_initialization_exists is
3679: select 1
3680: from per_time_periods ptp
3681: where ptp.regular_payment_date >= g_start_of_year
3682: and ptp.time_period_id in
3683: (
3684: select

Line 3827: per_time_periods ptp,

3823: ,g_ni_j_element_type_id
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'