APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PAY_PAYROLL_ACTIONS

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

53: ,p_segment_number IN NUMBER DEFAULT NULL
54: )
55: RETURN VARCHAR2
56: IS
57: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
58: l_start_pos NUMBER;
59: l_delimiter VARCHAR2 (1) := ' ';
60: l_proc VARCHAR2 (240) := g_package || ' get parameter ';
61: BEGIN

Line 149: FROM pay_payroll_actions

145: )
146: ) income_salary_year
147: ,effective_date effective_date
148: ,business_group_id bg_id
149: FROM pay_payroll_actions
150: WHERE payroll_action_id = p_payroll_action_id;
151:
152: lr_parameter_info csr_parameter_info%ROWTYPE;
153: l_proc VARCHAR2 (240)

Line 2272: ,pay_payroll_actions ppa

2268: -- *****************************************************************************
2269: p_sql :=
2270: 'SELECT DISTINCT person_id
2271: FROM per_people_f ppf
2272: ,pay_payroll_actions ppa
2273: WHERE ppa.payroll_action_id = :payroll_action_id
2274: AND ppa.business_group_id = ppf.business_group_id
2275: AND ppf.person_id = '''
2276: || g_person_id

Line 3107: FROM pay_payroll_actions ppa

3103: THEN
3104: BEGIN
3105: SELECT payroll_action_id
3106: INTO l_payroll_action_id
3107: FROM pay_payroll_actions ppa
3108: ,fnd_conc_req_summary_v fcrs
3109: ,fnd_conc_req_summary_v fcrs1
3110: WHERE fcrs.request_id = fnd_global.conc_request_id
3111: AND fcrs.priority_request_id = fcrs1.priority_request_id