DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD_REQ_PKG dependencies on PAY_PAYROLL_ACTIONS

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

9: p_parameter_string IN VARCHAR2
10: ,p_token IN VARCHAR2
11: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
12: IS
13: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
14: l_start_pos NUMBER;
15: l_delimiter varchar2(1):=' ';
16: l_proc VARCHAR2(60):= g_package||'get_parameter ';
17: BEGIN

Line 47: ,pay_payroll_actions ppa

43: IS
44: BEGIN
45: p_sqlstr := 'SELECT DISTINCT person_id
46: FROM per_people_f ppf
47: ,pay_payroll_actions ppa
48: WHERE ppa.payroll_action_id = :payroll_action_id
49: AND ppa.business_group_id = ppf.business_group_id
50: ORDER BY ppf.person_id';
51: END range_code;