DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_ALL_PAYROLLS

Line 194: pay_all_payrolls_f ppay,

190: FROM fnd_sessions fs,
191: hr_all_positions_f pp ,
192: per_shared_types pst ,
193: per_all_assignments_f paf ,
194: pay_all_payrolls_f ppay,
195: per_pay_bases ppb,
196: per_assignment_status_types past --bug 4020452
197: WHERE fs.session_id = userenv('sessionid')
198: AND fs.effective_date between pp.effective_start_date

Line 1702: pay_all_payrolls_f ppay,

1698: psb_positions_i pp,
1699: /* End bug #4128475 */
1700: per_all_assignments_f paf,
1701: per_all_people_f ppf,
1702: pay_all_payrolls_f ppay,
1703: per_pay_bases ppb
1704: WHERE fs.session_id = userenv('sessionid')
1705: AND fs.effective_date between paf.effective_start_date and paf.effective_end_date
1706: AND pp.data_extract_id = p_data_extract_id

Line 2410: from pay_all_payrolls pay, pay_cost_allocation_keyflex pcak

2406: Cursor C_payroll is
2407: Select pay.cost_allocation_keyflex_id ,
2408: pay.effective_start_date,
2409: pay.effective_end_date
2410: from pay_all_payrolls pay, pay_cost_allocation_keyflex pcak
2411: where pay.payroll_id = le_payroll_id
2412: and pay.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id;
2413:
2414: