APPS.PSP_ENC_SUM_TRAN dependencies on PA_TASKS

Line 4518: pa_tasks pt,

4514: DECODE(pec.uom, 'H', DECODE(SIGN(summary_amount), -1, 'Y')) unmatched_nve_txn_flag --6242618
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

Line 4799: fnd_message.set_token('TABLE', 'PA_TASKS');

4795:
4796: IF r_interface.task_number(recno) IS NULL THEN
4797: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4798: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4799: fnd_message.set_token('TABLE', 'PA_TASKS');
4800: fnd_msg_pub.add;
4801: l_raise_error := TRUE;
4802: END IF;
4803: END LOOP;

Line 5877: l_task_number pa_tasks.task_number%TYPE;

5873: l_task_id NUMBER(15);
5874: l_return_status VARCHAR2(1);
5875: l_cnt_gms_interface NUMBER;
5876: l_project_number pa_projects_all.segment1%TYPE;
5877: l_task_number pa_tasks.task_number%TYPE;
5878: l_award_number gms_awards_all.award_number%TYPE;
5879: l_exp_org_name hr_organization_units.name%TYPE;
5880: l_gl_description VARCHAR2(4000);
5881:

Line 5894: FROM pa_tasks

5890: WHERE award_id = l_award_id;
5891:
5892: CURSOR task_number_cur Is
5893: SELECT task_number
5894: FROM pa_tasks
5895: WHERE task_id = l_task_id;
5896:
5897: CURSOR exp_org_name_cur IS
5898: SELECT name

Line 6855: l_task_number pa_tasks.task_number%TYPE;

6851: l_full_name per_all_people_f.full_name%TYPE;
6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;
6854: l_project_number pa_projects_all.segment1%TYPE;
6855: l_task_number pa_tasks.task_number%TYPE;
6856: l_award_number gms_awards_all.award_number%TYPE;
6857: l_exp_org_name hr_organization_units.name%TYPE;
6858: l_gl_description VARCHAR2(4000);
6859: l_return_status VARCHAR2(1);

Line 6904: FROM pa_tasks

6900: WHERE award_id = p_award_id;
6901:
6902: CURSOR task_number_cur (p_task_id IN NUMBER) IS
6903: SELECT task_number
6904: FROM pa_tasks
6905: WHERE task_id = p_task_id;
6906:
6907: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
6908: SELECT name