APPS.PSP_LABOR_DIST dependencies on PSP_SCHEDULE_LINES

Line 1409: psp_schedule_lines psl

1405: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, psl.attribute8)) attribute8,
1406: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, psl.attribute9)) attribute9,
1407: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
1408: FROM psp_schedule_hierarchy psh,
1409: psp_schedule_lines psl
1410: WHERE psh.business_group_id = p_business_group_id
1411: AND psh.set_of_books_id = p_set_of_books_id
1412: AND psh.business_group_id = psl.business_group_id
1413: AND psh.set_of_books_id = psl.set_of_books_id

Line 1950: psp_schedule_lines psl

1946: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
1947: FROM psp_element_types pet,
1948: psp_group_element_list pgel,
1949: psp_schedule_hierarchy psh,
1950: psp_schedule_lines psl
1951: WHERE pet.element_type_id = p_element_type_id
1952: -- Introduced the following BG/SOB check for bug fix 3098050
1953: AND pet.business_group_id = p_business_group_id
1954: AND pet.set_of_books_id = p_set_of_books_id

Line 2534: psp_schedule_lines psl

2530: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, psl.attribute8)) attribute8,
2531: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, psl.attribute9)) attribute9,
2532: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
2533: FROM psp_schedule_hierarchy psh,
2534: psp_schedule_lines psl
2535: WHERE psh.business_group_id = p_business_group_id
2536: AND psh.set_of_books_id = p_set_of_books_id
2537: AND psh.scheduling_types_code = 'A'
2538: AND psh.element_group_id IS NULL

Line 5395: psp_schedule_lines psl,

5391: poa2.expenditure_organization_id), NULL) exp_org_id
5392: FROM Psp_distribution_lines pdl,
5393: psp_payroll_sub_lines ppsl,
5394: psp_payroll_lines ppl,
5395: psp_schedule_lines psl,
5396: psp_organization_accounts poa,
5397: psp_element_type_accounts peta,
5398: psp_default_labor_Schedules pdls,
5399: psp_organization_accounts poa2

Line 5715: -- Search for the assignment's element type in psp_schedule_lines

5711: end if;
5712:
5713: -- dbms_output.put_line('Before Element Earnings ');
5714: IF l_proc_executed = 'FALSE' THEN
5715: -- Search for the assignment's element type in psp_schedule_lines
5716:
5717: element_type_hierarchy(
5718: l_proc_executed,
5719: p_person_id,

Line 6096: psp_Schedule_lines psl,

6092: ppl.payroll_action_type
6093: FROM psp_distribution_lines pdl,
6094: psp_payroll_lines ppl,
6095: psp_payroll_sub_lines ppsl,
6096: psp_Schedule_lines psl,
6097: psp_schedule_hierarchy psh
6098: WHERE
6099: ppl.payroll_control_id = p_payroll_control_id
6100: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 7135: From psp_schedule_lines psl,

7131: :t_capped_sched_amount,
7132: :t_assignment_id,
7133: :t_excess_account,
7134: :t_excess_line_id
7135: From psp_schedule_lines psl,
7136: psp_organization_accounts pod,
7137: psp_element_type_accounts pea,
7138: psp_default_labor_schedules pdls,
7139: psp_payroll_controls ppc,

Line 7189: From psp_schedule_lines psl,

7185: :t_capped_sched_amount,
7186: :t_assignment_id,
7187: :t_excess_account,
7188: :t_excess_line_id
7189: From psp_schedule_lines psl,
7190: psp_organization_accounts pod,
7191: psp_element_type_accounts pea,
7192: psp_default_labor_schedules pdls,
7193: psp_payroll_controls ppc,