APPS.PSP_LABOR_DIST dependencies on PSP_SQL_TAB_NUMBER15

Line 6978: t_dist_line_id psp_sql_tab_number15;

6974: and language = userenv('LANG')
6975: and enabled_flag = 'Y'
6976: and p_tp_start_date between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'));
6977:
6978: t_dist_line_id psp_sql_tab_number15;
6979: t_dist_date psp_sql_tab_date;
6980: t_dist_amount psp_sql_tab_number;
6981: t_assignment_id psp_sql_tab_number15;
6982: t_excess_line_id psp_sql_tab_number15;

Line 6981: t_assignment_id psp_sql_tab_number15;

6977:
6978: t_dist_line_id psp_sql_tab_number15;
6979: t_dist_date psp_sql_tab_date;
6980: t_dist_amount psp_sql_tab_number;
6981: t_assignment_id psp_sql_tab_number15;
6982: t_excess_line_id psp_sql_tab_number15;
6983: t_excess_account psp_sql_tab_number15;
6984: t_cap_sched_amount psp_sql_tab_number;
6985:

Line 6982: t_excess_line_id psp_sql_tab_number15;

6978: t_dist_line_id psp_sql_tab_number15;
6979: t_dist_date psp_sql_tab_date;
6980: t_dist_amount psp_sql_tab_number;
6981: t_assignment_id psp_sql_tab_number15;
6982: t_excess_line_id psp_sql_tab_number15;
6983: t_excess_account psp_sql_tab_number15;
6984: t_cap_sched_amount psp_sql_tab_number;
6985:
6986: cursor check_excess_poeta(p_dist_line_id number) is

Line 6983: t_excess_account psp_sql_tab_number15;

6979: t_dist_date psp_sql_tab_date;
6980: t_dist_amount psp_sql_tab_number;
6981: t_assignment_id psp_sql_tab_number15;
6982: t_excess_line_id psp_sql_tab_number15;
6983: t_excess_account psp_sql_tab_number15;
6984: t_cap_sched_amount psp_sql_tab_number;
6985:
6986: cursor check_excess_poeta(p_dist_line_id number) is
6987: select pdl.cap_excess_project_id,

Line 7481: t_dist_line_id := psp_sql_tab_number15(null);

7477: close check_excess_poeta;
7478: end loop; --- apply suspense
7479:
7480: End loop; --- salary Cap array.
7481: t_dist_line_id := psp_sql_tab_number15(null);
7482: t_dist_date := psp_sql_tab_date(null);
7483: t_dist_amount := psp_sql_tab_number(null);
7484: t_assignment_id := psp_sql_tab_number15(null);
7485: t_excess_line_id := psp_sql_tab_number15(null);

Line 7484: t_assignment_id := psp_sql_tab_number15(null);

7480: End loop; --- salary Cap array.
7481: t_dist_line_id := psp_sql_tab_number15(null);
7482: t_dist_date := psp_sql_tab_date(null);
7483: t_dist_amount := psp_sql_tab_number(null);
7484: t_assignment_id := psp_sql_tab_number15(null);
7485: t_excess_line_id := psp_sql_tab_number15(null);
7486: t_excess_account := psp_sql_tab_number15(null);
7487: t_cap_sched_amount := psp_sql_tab_number(null);
7488: t_dist_line_id.delete;

Line 7485: t_excess_line_id := psp_sql_tab_number15(null);

7481: t_dist_line_id := psp_sql_tab_number15(null);
7482: t_dist_date := psp_sql_tab_date(null);
7483: t_dist_amount := psp_sql_tab_number(null);
7484: t_assignment_id := psp_sql_tab_number15(null);
7485: t_excess_line_id := psp_sql_tab_number15(null);
7486: t_excess_account := psp_sql_tab_number15(null);
7487: t_cap_sched_amount := psp_sql_tab_number(null);
7488: t_dist_line_id.delete;
7489: t_dist_date.delete;

Line 7486: t_excess_account := psp_sql_tab_number15(null);

7482: t_dist_date := psp_sql_tab_date(null);
7483: t_dist_amount := psp_sql_tab_number(null);
7484: t_assignment_id := psp_sql_tab_number15(null);
7485: t_excess_line_id := psp_sql_tab_number15(null);
7486: t_excess_account := psp_sql_tab_number15(null);
7487: t_cap_sched_amount := psp_sql_tab_number(null);
7488: t_dist_line_id.delete;
7489: t_dist_date.delete;
7490: t_dist_amount.delete;