APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 2314: pay_cost_allocation_keyflex pcak

2310: pcaf.effective_start_date,
2311: pcaf.effective_end_date
2312: from fnd_sessions fs, per_all_assignments_f paf,
2313: pay_cost_allocations_f pcaf,
2314: pay_cost_allocation_keyflex pcak
2315: where fs.session_id = userenv('sessionid')
2316: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2317: and paf.business_group_id = p_business_group_id
2318: and paf.payroll_id > l_restart_payroll_id

Line 2407: Select pay.cost_allocation_keyflex_id ,

2403: from gl_sets_of_books
2404: where set_of_books_id = p_set_of_books_id;
2405:
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

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:

Line 2412: and pay.cost_allocation_keyflex_id = pcak.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:
2415: Cursor C_Pay_basis is
2416: Select element_type_id

Line 2427: pay_cost_allocation_keyflex pcak, Pay_element_types pet

2423: Select pel.cost_allocation_keyflex_id ,
2424: pel.effective_start_date,
2425: pel.effective_end_date
2426: from Pay_element_entries pee,Pay_element_links pel,
2427: pay_cost_allocation_keyflex pcak, Pay_element_types pet
2428: where pee.assignment_id = le_assignment_id
2429: and pee.element_link_id = pel.element_link_id
2430: and pel.element_type_id = pet.element_type_id
2431: and pet.element_type_id = le_element_type_id

Line 2438: from hr_organization_units hru, pay_cost_allocation_keyflex pcak

2434: Cursor C_Org is
2435: Select hru.cost_allocation_keyflex_id ,
2436: hru.date_from,
2437: hru.date_to
2438: from hr_organization_units hru, pay_cost_allocation_keyflex pcak
2439: where hru.organization_id = le_organization_id
2440: and hru.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id;
2441:
2442: Cursor C_Segcount is

Line 4989: ' From pay_cost_allocations,pay_cost_allocation_keyflex '||

4985: stmt_flag := 'T';
4986: end if;
4987: if ((l_attribute_id <> prev_attribute_id) or (prev_attribute_id = -1)) then
4988: l_sql_stmt := 'Select '||l_application_column_name||
4989: ' From pay_cost_allocations,pay_cost_allocation_keyflex '||
4990: ' Where pay_cost_allocations.assignment_id = '||
4991: ':lc_assignment_id'||
4992: ' and pay_cost_allocations.cost_allocation_keyflex_id = '||
4993: ' pay_cost_allocation_keyflex.cost_allocation_keyflex_id '||

Line 4993: ' pay_cost_allocation_keyflex.cost_allocation_keyflex_id '||

4989: ' From pay_cost_allocations,pay_cost_allocation_keyflex '||
4990: ' Where pay_cost_allocations.assignment_id = '||
4991: ':lc_assignment_id'||
4992: ' and pay_cost_allocations.cost_allocation_keyflex_id = '||
4993: ' pay_cost_allocation_keyflex.cost_allocation_keyflex_id '||
4994: ' order by pay_cost_allocations.proportion';
4995: dbms_sql.parse(v_cursorid,l_sql_stmt,dbms_sql.v7);
4996: dbms_sql.define_column(v_cursorid,1,v_segment,80);
4997: if (stmt_flag = 'T') then

Line 7389: from pay_cost_allocation_keyflex

7385: segment19, segment20, segment21,
7386: segment22, segment23, segment24,
7387: segment25, segment26, segment27,
7388: segment28, segment29, segment30
7389: from pay_cost_allocation_keyflex
7390: where cost_allocation_keyflex_id = pcost_allocation_keyflex_id;
7391:
7392: begin
7393: