APPS.PSP_ENC_SUM_TRAN dependencies on PER_TIME_PERIODS

Line 972: PER_TIME_PERIODS PTP,

968: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute8, pos.attribute8), NULL) attribute8,
969: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute9, pos.attribute9), NULL) attribute9,
970: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute10, pos.attribute10), NULL) attribute10
971: FROM PSP_ENC_LINES PEL,
972: PER_TIME_PERIODS PTP,
973: -- ,GL_SETS_OF_BOOKS SOB,
974: -- GL_CODE_COMBINATIONS GCC,
975: PSP_ORGANIZATION_ACCOUNTS POS
976: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 1020: PER_TIME_PERIODS PTP

1016: pel.gl_code_combination_id gl_ccid
1017: -- sob.set_of_books_id,
1018: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1019: FROM PSP_ENC_LINES PEL,
1020: PER_TIME_PERIODS PTP
1021: -- ,GL_SETS_OF_BOOKS SOB,
1022: -- GL_CODE_COMBINATIONS GCC,
1023: -- PSP_ORGANIZATION_ACCOUNTS POS
1024: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 1054: PER_TIME_PERIODS PTP

1050: pel.gl_code_combination_id gl_ccid
1051: -- sob.set_of_books_id,
1052: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1053: FROM PSP_ENC_LINES PEL,
1054: PER_TIME_PERIODS PTP
1055: -- ,GL_SETS_OF_BOOKS SOB,
1056: -- GL_CODE_COMBINATIONS GCC,
1057: -- PSP_ORGANIZATION_ACCOUNTS POS
1058: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 2049: FROM per_time_periods

2045:
2046: BEGIN
2047: SELECT period_name, end_date
2048: INTO l_period_name, l_period_end_dt
2049: FROM per_time_periods
2050: WHERE time_period_id = enc_control_rec.time_period_id;
2051: EXCEPTION
2052: WHEN NO_DATA_FOUND THEN
2053: l_value := 'time period id =';

Line 2054: l_table := 'PER_TIME_PERIODS';

2050: WHERE time_period_id = enc_control_rec.time_period_id;
2051: EXCEPTION
2052: WHEN NO_DATA_FOUND THEN
2053: l_value := 'time period id =';
2054: l_table := 'PER_TIME_PERIODS';
2055: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2056: fnd_message.set_token('VALUE','l_value');
2057: fnd_message.set_token('TABLE','l_table');
2058: fnd_msg_pub.add;

Line 3382: per_time_periods ptp

3378: pesl.interface_status,
3379: ptp.end_date
3380: FROM psp_enc_lines pel,
3381: psp_enc_summary_lines pesl,
3382: per_time_periods ptp
3383: WHERE pel.payroll_action_id = p_payroll_action_id
3384: AND pel.enc_summary_line_id = pesl.enc_summary_line_id
3385: AND pesl.payroll_action_id = p_payroll_action_id
3386: AND pesl.status_code = 'R'

Line 4163: PER_TIME_PERIODS PTP,

4159: pel.expenditure_type,
4160: pel.expenditure_organization_id * /
4161: -- ,pai.set_of_books_id
4162: FROM PSP_ENC_LINES PEL,
4163: PER_TIME_PERIODS PTP,
4164: PSP_ORGANIZATION_ACCOUNTS POA
4165: -- ,PA_IMPLEMENTATIONS_ALL PAI
4166: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
4167: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE

Line 4624: per_time_periods ptp,

4620: FROM psp_enc_summary_lines pesl,
4621: hr_organization_units hou,
4622: pa_projects_all ppa,
4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
4624: per_time_periods ptp,
4625: psp_enc_controls pec
4626: ,per_all_people_f papf --Added for Bug 10126350
4627: WHERE pec.payroll_action_id = p_payroll_action_id
4628: AND pec.enc_control_id = pesl.enc_control_id

Line 5956: per_time_periods ptp

5952: pesl.interface_status,
5953: ptp.end_date
5954: FROM psp_enc_lines pel,
5955: psp_enc_summary_lines pesl,
5956: per_time_periods ptp
5957: WHERE pel.payroll_action_id = p_payroll_action_id
5958: AND pel.enc_summary_line_id = pesl.enc_summary_line_id
5959: AND pesl.payroll_action_id = p_payroll_action_id
5960: AND pesl.status_code = 'R'