APPS.PAY_SE_SLSA_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

29: p_token IN VARCHAR2,
30: p_segment_number IN NUMBER DEFAULT NULL
31: )
32: RETURN VARCHAR2 IS
33: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
34: l_start_pos NUMBER;
35: l_delimiter VARCHAR2 (1) := ' ';
36: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
37: BEGIN

Line 112: FROM pay_payroll_actions

108: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
109: (pay_se_slsa_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
110: eff_end_date,
111: effective_date effective_date, business_group_id bg_id
112: FROM pay_payroll_actions
113: WHERE payroll_action_id = p_payroll_action_id;
114:
115: lr_parameter_info csr_parameter_info%ROWTYPE;
116: l_proc VARCHAR2 (240) := g_package || ' GET_ALL_PARAMETERS ';

Line 454: FROM pay_assignment_actions paa, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv

450: p_report_end_date DATE,
451: p_input_value_id NUMBER
452: ) IS
453: SELECT prrv.result_value start_date
454: FROM pay_assignment_actions paa, pay_payroll_actions ppa, pay_run_results prr, pay_run_result_values prrv
455: WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
456: AND ppa.payroll_action_id = paa.payroll_action_id
457: AND paa.assignment_id = p_assignment_id
458: AND paa.assignment_action_id = prr.assignment_action_id

Line 476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,

472: SELECT sum (fnd_number.canonical_to_number (result_value))
473: FROM pay_run_result_values prrv
474: WHERE input_value_id = p_input_value_id
475: AND run_result_id IN (SELECT prr.run_result_id
476: FROM pay_assignment_actions paa, pay_payroll_actions ppa,pay_run_result_values prrv1,
477: pay_run_results prr
478: WHERE ppa.effective_date BETWEEN p_report_start_date AND p_report_end_date
479: AND ppa.payroll_action_id = paa.payroll_action_id
480: AND paa.assignment_id = p_assignment_id

Line 924: ,pay_payroll_actions ppa

920:
921: p_sql :=
922: 'SELECT DISTINCT person_id
923: FROM per_people_f ppf
924: ,pay_payroll_actions ppa
925: WHERE ppa.payroll_action_id = :payroll_action_id
926: AND ppa.business_group_id = ppf.business_group_id
927: ORDER BY ppf.person_id';
928: g_payroll_action_id := p_payroll_action_id;