APPS.PAY_SE_ARCHIVE_TETA dependencies on PAY_PAYROLL_ACTIONS

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

26: p_parameter_string IN VARCHAR2
27: ,p_token IN VARCHAR2
28: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
29: IS
30: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
31: l_start_pos NUMBER;
32: l_delimiter VARCHAR2(1):=' ';
33: l_proc VARCHAR2(240):= g_package||' get parameter ';
34: BEGIN

Line 89: FROM pay_payroll_actions

85: ,fnd_date.canonical_to_date(PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'DATE_REPORT'))
86: ,PAY_SE_ARCHIVE_TETA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,effective_date
88: ,business_group_id
89: FROM pay_payroll_actions
90: WHERE payroll_action_id = p_payroll_action_id;
91: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
92: --
93: BEGIN

Line 148: ,pay_payroll_actions ppa

144: END IF;
145:
146: p_sql := 'SELECT DISTINCT person_id
147: FROM per_people_f ppf
148: ,pay_payroll_actions ppa
149: WHERE ppa.payroll_action_id = :payroll_action_id
150: AND ppa.business_group_id = ppf.business_group_id
151: AND ROWNUM < 2
152: ORDER BY ppf.person_id';

Line 645: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

641: END ARCHIVE_CODE;
642:
643:
644: PROCEDURE DEINITIALIZATION_CODE
645: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
646:
647:
648: l_years_worked NUMBER;
649: l_days_worked NUMBER;