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 2232: ,pay_payroll_actions ppa

2228: -- *****************************************************************************
2229: p_sql :=
2230: 'SELECT DISTINCT person_id
2231: FROM per_people_f ppf
2232: ,pay_payroll_actions ppa
2233: WHERE ppa.payroll_action_id = :payroll_action_id
2234: AND ppa.business_group_id = ppf.business_group_id
2235: AND ppf.person_id = '''
2236: || g_person_id

Line 3067: FROM pay_payroll_actions ppa

3063: THEN
3064: BEGIN
3065: SELECT payroll_action_id
3066: INTO l_payroll_action_id
3067: FROM pay_payroll_actions ppa
3068: ,fnd_conc_req_summary_v fcrs
3069: ,fnd_conc_req_summary_v fcrs1
3070: WHERE fcrs.request_id = fnd_global.conc_request_id
3071: AND fcrs.priority_request_id = fcrs1.priority_request_id