APPS.PSP_ENC_SUM_TRAN dependencies on PER_TIME_PERIODS

Line 952: PER_TIME_PERIODS PTP,

948: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute8, pos.attribute8), NULL) attribute8,
949: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute9, pos.attribute9), NULL) attribute9,
950: DECODE(g_dff_grouping_option, 'Y', DECODE(suspense_org_account_id, NULL, pel.attribute10, pos.attribute10), NULL) attribute10
951: FROM PSP_ENC_LINES PEL,
952: PER_TIME_PERIODS PTP,
953: -- ,GL_SETS_OF_BOOKS SOB,
954: -- GL_CODE_COMBINATIONS GCC,
955: PSP_ORGANIZATION_ACCOUNTS POS
956: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 1000: PER_TIME_PERIODS PTP

996: pel.gl_code_combination_id gl_ccid
997: -- sob.set_of_books_id,
998: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
999: FROM PSP_ENC_LINES PEL,
1000: PER_TIME_PERIODS PTP
1001: -- ,GL_SETS_OF_BOOKS SOB,
1002: -- GL_CODE_COMBINATIONS GCC,
1003: -- PSP_ORGANIZATION_ACCOUNTS POS
1004: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 1034: PER_TIME_PERIODS PTP

1030: pel.gl_code_combination_id gl_ccid
1031: -- sob.set_of_books_id,
1032: -- decode(suspense_org_account_id, null, pel.gl_code_combination_id, pos.gl_code_combination_id) gl_ccid
1033: FROM PSP_ENC_LINES PEL,
1034: PER_TIME_PERIODS PTP
1035: -- ,GL_SETS_OF_BOOKS SOB,
1036: -- GL_CODE_COMBINATIONS GCC,
1037: -- PSP_ORGANIZATION_ACCOUNTS POS
1038: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID

Line 2028: FROM per_time_periods

2024:
2025: BEGIN
2026: SELECT period_name, end_date
2027: INTO l_period_name, l_period_end_dt
2028: FROM per_time_periods
2029: WHERE time_period_id = enc_control_rec.time_period_id;
2030: EXCEPTION
2031: WHEN NO_DATA_FOUND THEN
2032: l_value := 'time period id =';

Line 2033: l_table := 'PER_TIME_PERIODS';

2029: WHERE time_period_id = enc_control_rec.time_period_id;
2030: EXCEPTION
2031: WHEN NO_DATA_FOUND THEN
2032: l_value := 'time period id =';
2033: l_table := 'PER_TIME_PERIODS';
2034: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2035: fnd_message.set_token('VALUE','l_value');
2036: fnd_message.set_token('TABLE','l_table');
2037: fnd_msg_pub.add;

Line 3340: per_time_periods ptp

3336: pesl.interface_status,
3337: ptp.end_date
3338: FROM psp_enc_lines pel,
3339: psp_enc_summary_lines pesl,
3340: per_time_periods ptp
3341: WHERE pel.payroll_action_id = p_payroll_action_id
3342: AND pel.enc_summary_line_id = pesl.enc_summary_line_id
3343: AND pesl.payroll_action_id = p_payroll_action_id
3344: AND pesl.status_code = 'R'

Line 4059: PER_TIME_PERIODS PTP,

4055: pel.expenditure_type,
4056: pel.expenditure_organization_id * /
4057: -- ,pai.set_of_books_id
4058: FROM PSP_ENC_LINES PEL,
4059: PER_TIME_PERIODS PTP,
4060: PSP_ORGANIZATION_ACCOUNTS POA
4061: -- ,PA_IMPLEMENTATIONS_ALL PAI
4062: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
4063: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE

Line 4519: per_time_periods ptp,

4515: FROM psp_enc_summary_lines pesl,
4516: hr_organization_units hou,
4517: pa_projects_all ppa,
4518: pa_tasks pt,
4519: per_time_periods ptp,
4520: psp_enc_controls pec
4521: WHERE pec.payroll_action_id = p_payroll_action_id
4522: AND pec.enc_control_id = pesl.enc_control_id
4523: AND pesl.status_code = 'N'

Line 5773: per_time_periods ptp

5769: pesl.interface_status,
5770: ptp.end_date
5771: FROM psp_enc_lines pel,
5772: psp_enc_summary_lines pesl,
5773: per_time_periods ptp
5774: WHERE pel.payroll_action_id = p_payroll_action_id
5775: AND pel.enc_summary_line_id = pesl.enc_summary_line_id
5776: AND pesl.payroll_action_id = p_payroll_action_id
5777: AND pesl.status_code = 'R'