APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

27: FUNCTION get_parameter
28: (p_parameter_string IN VARCHAR2
29: ,p_token IN VARCHAR) RETURN VARCHAR2 IS
30: --
31: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
32: l_start_pos NUMBER;
33: l_delimiter VARCHAR2(1) := ' ';
34: --
35: BEGIN

Line 77: FROM pay_payroll_actions

73: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'END_DATE')) end_date
74: ,GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
75: ,business_group_id BG_ID
76: ,effective_date
77: FROM pay_payroll_actions
78: WHERE payroll_action_id = p_payroll_action_id;
79:
80:
81: lr_parameter_info csr_parameter_info%ROWTYPE;

Line 117: FROM pay_payroll_actions

113: SELECT business_group_id
114: ,legislative_parameters
115: ,get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
116: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date
117: FROM pay_payroll_actions
118: WHERE payroll_action_id = p_payroll_action_id;
119: --
120: l_parameter_rec csr_parameters%ROWTYPE;
121: --

Line 196: ,pay_payroll_actions ppa

192: END IF;
193:
194: p_sql := 'SELECT DISTINCT person_id
195: FROM per_people_f ppf
196: ,pay_payroll_actions ppa
197: WHERE ppa.payroll_action_id = :payroll_action_id
198: AND ppa.business_group_id = ppf.business_group_id
199: ORDER BY ppf.person_id';
200:

Line 492: pay_payroll_actions ppa,

488: prrv2.result_value full_day,
489: fnd_date.canonical_to_date(prrv3.result_value) end_date,
490: prrv4.result_value part_day
491: FROM pay_assignment_actions paa,
492: pay_payroll_actions ppa,
493: pay_run_results prr,
494: pay_run_result_values prrv1,
495: pay_run_result_values prrv2,
496: pay_run_result_values prrv3,

Line 525: pay_payroll_actions ppa,

521: p_full_day_iv NUMBER,
522: p_source_id NUMBER) IS
523: SELECT max(to_number(prrv1.result_value)) full_day
524: FROM pay_assignment_actions paa,
525: pay_payroll_actions ppa,
526: pay_run_results prr,
527: pay_run_result_values prrv1
528: WHERE ppa.effective_date BETWEEN p_report_start_date
529: AND p_report_end_date

Line 553: pay_payroll_actions ppa,

549: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,
550: fnd_date.canonical_to_date(prrv3.result_value) end_date,
551: prrv4.result_value employer_days
552: FROM pay_assignment_actions paa,
553: pay_payroll_actions ppa,
554: pay_run_results prr,
555: pay_run_result_values prrv1,
556: pay_run_result_values prrv2,
557: pay_run_result_values prrv3,

Line 1137: pay_payroll_actions paa,

1133: pai.action_information10 full_day,
1134: pai.action_information11 part_day,
1135: pai.action_information12 correction
1136: FROM
1137: pay_payroll_actions paa,
1138: pay_assignment_actions assg,
1139: pay_action_information pai
1140: WHERE
1141: paa.payroll_action_id = p_payroll_action_id

Line 1175: FROM pay_payroll_actions ppa,

1171: BEGIN
1172:
1173: SELECT payroll_action_id
1174: INTO l_payroll_action_id
1175: FROM pay_payroll_actions ppa,
1176: fnd_conc_req_summary_v fcrs,
1177: fnd_conc_req_summary_v fcrs1
1178: WHERE fcrs.request_id = fnd_global.conc_request_id
1179: AND fcrs.priority_request_id = fcrs1.priority_request_id