APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 144: l_parameter pay_payroll_actions.legislative_parameters%TYPE;

140: FUNCTION get_parameter(
141: p_parameter_string IN VARCHAR2
142: ,p_token IN VARCHAR2) RETURN VARCHAR2 IS
143: --
144: l_parameter pay_payroll_actions.legislative_parameters%TYPE;
145: l_start_pos NUMBER;
146: l_delimiter VARCHAR2(1);
147: --
148: BEGIN

Line 185: FROM pay_payroll_actions

181: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'SES_DATE')
182: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ORG_ID')
183: ,PER_ES_SS_REP_ARCHIVE_PKG.get_parameter(legislative_parameters, 'ASG_SET_ID')
184: ,business_group_id
185: FROM pay_payroll_actions
186: WHERE payroll_action_id = p_payroll_action_id;
187: --
188: l_effective_Date VARCHAR2(50);
189: l_test_flag VARCHAR2(1);

Line 219: FROM pay_payroll_actions

215: --
216: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
217: SELECT per_es_ss_rep_archive_pkg.get_parameter(legislative_parameters
218: ,'PAYROLL_ACTION_ID')
219: FROM pay_payroll_actions
220: WHERE payroll_action_id = p_payroll_action_id;
221: --
222: CURSOR csr_parameter_info_date(p_payroll_action_id NUMBER) IS
223: SELECT effective_date

Line 224: FROM pay_payroll_actions

220: WHERE payroll_action_id = p_payroll_action_id;
221: --
222: CURSOR csr_parameter_info_date(p_payroll_action_id NUMBER) IS
223: SELECT effective_date
224: FROM pay_payroll_actions
225: WHERE payroll_action_id = p_payroll_action_id;
226: --
227: l_payroll_action_id VARCHAR2(15);
228: --

Line 371: ,pay_payroll_actions ppa

367: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
368: ELSE
369: sqlstr := 'SELECT distinct person_id
370: FROM per_people_f ppf
371: ,pay_payroll_actions ppa
372: WHERE ppa.payroll_action_id = :payroll_action_id
373: AND ppa.business_group_id = ppf.business_group_id
374: ORDER BY ppf.person_id';
375: END IF;

Line 1466: ,pay_payroll_actions ppa

1462: -- Return the select string
1463: --
1464: sqlstr := 'select distinct person_id
1465: from per_people_f ppf
1466: ,pay_payroll_actions ppa
1467: where ppa.payroll_action_id = :payroll_action_id
1468: and ppa.business_group_id = ppf.business_group_id
1469: order by ppf.person_id';
1470: EXCEPTION

Line 1488: FROM pay_payroll_actions ppa

1484: SELECT asg_run.assignment_id assignment_id
1485: ,pai.action_context_id action_context_id
1486: ,pai.action_information1 action_status
1487: ,max(pai.effective_date) current_reporting_date
1488: FROM pay_payroll_actions ppa
1489: ,pay_assignment_actions paa
1490: ,per_all_assignments_f asg_run
1491: ,pay_action_information pai
1492: WHERE ppa.payroll_action_id = c_payroll_action_id