APPS.PAY_JP_SPR_EFILE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 12: g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;

8: c_max_file_open number := 50;
9: --
10: g_bg_itax_dpnt_ref_type varchar2(150);
11: g_ass_set_formula_id number;
12: g_ass_set_amendment_type hr_assignment_set_amendments.include_or_exclude%type;
13: g_file_dir fnd_concurrent_processes.plsql_dir%type;
14: --
15: g_warning_exist varchar2(1);
16: g_warning_header varchar2(1);

Line 32: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);

28: assignment_id number,
29: assignment_action_id number,
30: effective_date date,
31: spr_term_valid number,
32: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
33: type t_ass_tbl is table of t_ass_rec index by binary_integer;
34: g_ass_tbl t_ass_tbl;
35: g_ass_ind_tbl t_ass_tbl;
36: --

Line 439: := 'hr_assignment_set_amendments hasa,';

435: c_proc_ass_hasa_select_clause varchar2(32767)
436: := ', hasa.include_or_exclude';
437: --
438: c_proc_ass_hasa_from_clause varchar2(32767)
439: := 'hr_assignment_set_amendments hasa,';
440: --
441: c_proc_ass_hasa_where_clause varchar2(32767)
442: := '(to_number(decode(nvl(''i_ass_set_formula_id'',''-1''),''-1'',
443: decode(nvl(''i_ass_set_amendment_type'',''X''),''I'',hasa.assignment_id,wic_v.assignment_id),

Line 506: := 'hr_assignment_set_amendments hasa,';

502: c_proc_arch_hasa_select_clause varchar2(32767)
503: := ', hasa.include_or_exclude';
504: --
505: c_proc_arch_hasa_from_clause varchar2(32767)
506: := 'hr_assignment_set_amendments hasa,';
507: --
508: c_proc_arch_hasa_where_clause varchar2(32767)
509: := '(to_number(decode(nvl(''i_ass_set_formula_id'',''-1''),''-1'',
510: decode(nvl(''i_ass_set_amendment_type'',''X''),''I'',hasa.assignment_id,paa.assignment_id),