APPS.PAY_DK_ARCHIVE_EHOL dependencies on PER_ASSIGNMENTS_F

Line 364: per_assignments_f paf,

360: ,'Lunar Month' ,'4') PAYROLL_PERIOD,
361: ptp.TIME_PERIOD_ID
362: FROM
363: pay_payrolls_f ppf,
364: per_assignments_f paf,
365: hr_organization_units hou,
366: hr_organization_information hoi,
367: hr_soft_coding_keyflex scl,
368: per_time_periods ptp

Line 1254: per_assignments_f paf,

1250: --ptp.period_name
1251:
1252: FROM
1253: pay_payrolls_f ppf,
1254: per_assignments_f paf,
1255: per_time_periods ptp
1256: WHERE paf.payroll_id = ppf.payroll_id
1257: AND paf.assignment_id=c_assignment_id
1258: AND ppf.payroll_id=NVL(g_payroll_id,ppf.payroll_id)

Line 1912: per_assignments_f paf,

1908: /*
1909: l_select_qry := l_select_str
1910: ||' FROM
1911: pay_payrolls_f ppf,
1912: per_assignments_f paf,
1913: per_time_periods ptp
1914: WHERE paf.payroll_id = ppf.payroll_id
1915: AND paf.assignment_id= ' || l_ass_id
1916: || l_where_clause