APPS.PAY_SE_TAX_DECL dependencies on PAY_PAYROLL_ACTIONS

Line 26: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

22: p_parameter_string IN VARCHAR2
23: ,p_token IN VARCHAR2
24: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
25: IS
26: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
27: l_start_pos NUMBER;
28: l_delimiter VARCHAR2(1):=' ';
29:
30: BEGIN

Line 107: FROM pay_payroll_actions

103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')
104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,effective_date
106: ,business_group_id
107: FROM pay_payroll_actions
108: WHERE payroll_action_id = p_payroll_action_id;
109:
110: BEGIN
111:

Line 313: pay_payroll_actions ppa

309: hr_organization_information hoi3,
310: hr_organization_information hoi4,
311: hr_organization_information hoi5,
312: pay_assignment_actions paa,
313: pay_payroll_actions ppa
314: where
315: ou.organization_id=hoi1.organization_id
316: and hoi1.org_information_context='CLASS'
317: and hoi1.org_information1='HR_LEGAL_EMPLOYER'

Line 348: ,pay_payroll_actions ppa

344:
345: -- the sql string to return
346: sqlstr := 'SELECT DISTINCT person_id
347: FROM per_people_f ppf
348: ,pay_payroll_actions ppa
349: WHERE ppa.payroll_action_id = :payroll_action_id
350: AND ppa.business_group_id = ppf.business_group_id
351: ORDER BY ppf.person_id';
352: