APPS.PAY_ZA_TAX_REG_AR dependencies on PAY_PAYROLLS_F

Line 27: g_payroll_id pay_payrolls_f.payroll_id%type ;

23: ------------------
24: g_package constant varchar2(30):= 'pay_za_tax_reg_rep.';
25:
26: -- Legislative Parameters
27: g_payroll_id pay_payrolls_f.payroll_id%type ;
28: g_st_period_id per_time_periods.time_period_id%type;
29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;

Line 30: g_payroll_name pay_payrolls_f.payroll_name%type := null;

26: -- Legislative Parameters
27: g_payroll_id pay_payrolls_f.payroll_id%type ;
28: g_st_period_id per_time_periods.time_period_id%type;
29: g_end_period_id per_time_periods.time_period_id%type;
30: g_payroll_name pay_payrolls_f.payroll_name%type := null;
31: g_end_period_date per_time_periods.end_date%type;
32: g_inc_all_asg VARCHAR2(1);
33: g_spc_asg_id per_all_assignments_f.assignment_id%TYPE;
34: g_ret_ptd VARCHAR2(1);

Line 103: pay_payrolls_f PPY,

99: /*
100: sqlstr :=
101: 'SELECT distinct PAF.person_id
102: FROM per_assignments_f PAF,
103: pay_payrolls_f PPY,
104: pay_payroll_actions PPA
105: WHERE PPA.payroll_action_id = :payroll_action_id
106: AND PAF.business_group_id = PPA.business_group_id
107: AND PPY.payroll_id = PAF.payroll_id

Line 116: pay_payrolls_f PPY,

112: -- new range cursor
113: sqlstr :=
114: 'SELECT distinct PAF.person_id
115: FROM per_assignments_f PAF,
116: pay_payrolls_f PPY,
117: pay_payroll_actions PPA,
118: per_assignment_extra_info AEI
119: WHERE PPA.payroll_action_id = :payroll_action_id
120: AND PAF.business_group_id = PPA.business_group_id