APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_PAYROLLS_F

Line 3139: from pay_payrolls_f PPF,

3135: hr_utility.trace(' v_period_hours is TRUE');
3136:
3137: select TPT.number_per_fiscal_year
3138: into v_periods_per_fiscal_yr
3139: from pay_payrolls_f PPF,
3140: per_time_period_types TPT,
3141: fnd_sessions fs
3142: where PPF.payroll_id = p_payroll
3143: and fs.session_id = USERENV('SESSIONID')

Line 3161: FROM pay_payrolls_f PRL,

3157: hr_utility.trace(' v_pay_basis = PERIOD');
3158:
3159: SELECT TPT.number_per_fiscal_year
3160: INTO v_annualizing_factor
3161: FROM pay_payrolls_f PRL,
3162: per_time_period_types TPT,
3163: fnd_sessions fs
3164: WHERE TPT.period_type = PRL.period_type
3165: and fs.session_id = USERENV('SESSIONID')

Line 3215: FROM pay_payrolls_f PRL,

3211: hr_utility.trace('Get annuallizing factor from period type of the payroll');
3212:
3213: SELECT TPT.number_per_fiscal_year
3214: INTO v_annualizing_factor
3215: FROM pay_payrolls_f PRL,
3216: per_time_period_types TPT,
3217: fnd_sessions fs
3218: WHERE TPT.period_type = PRL.period_type
3219: and fs.session_id = USERENV('SESSIONID')

Line 3313: from pay_payrolls_f PPF,

3309: hr_utility.trace('v_period_hours = TRUE');
3310:
3311: select TPT.number_per_fiscal_year
3312: into v_periods_per_fiscal_yr
3313: from pay_payrolls_f PPF,
3314: per_time_period_types TPT,
3315: fnd_sessions fs
3316: where PPF.payroll_id = p_payroll
3317: and fs.session_id = USERENV('SESSIONID')