DBA Data[Home] [Help]

APPS.PA_HR_TRANSACTIONS dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 14: from PA_TRANSACTION_INTERFACE_ALL pa,

10: dummy1 varchar2(1);
11:
12: cursor trans_interface( p_person_id number ) is
13: select null
14: from PA_TRANSACTION_INTERFACE_ALL pa,
15: --FP M CWK changes
16: --PER_PEOPLE_F ppf
17: PER_ALL_PEOPLE_F ppf
18: --where pa.employee_number = ppf.employee_number

Line 77: FROM pa_transaction_interface_all

73: /* Bug#3211124 - Take care of the case - id support introduced in FP K */
74: BEGIN
75: SELECT null
76: INTO dummy1
77: FROM pa_transaction_interface_all
78: WHERE person_id = p_person_id
79: AND transaction_status_code <> 'A'
80: AND rownum = 1;
81: